Use the Distinct type definition dialog to create a new distinct type or to view the definition of an existing distinct type.
Name
The name of the data type.Type schema
The schema where the distinct type is to reside.Source data type
Use the Source data type to specify information about the type that you are creating or display information about the existing type. Depending on the type that you select, you may have to specify other information. For details, see Data type controls.Text
A description of the distinct type.
To view the SQL used to create this object, click Show SQL.
For more details about built in type, see Data type.