Only Dynamic Server supports this statement, which is an extension to the ANSI/ISO standard for SQL.
>>-DROP TYPE--+------------+--data_type--RESTRICT-------------->< '- owner-- .-'
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| data_type | Distinct or opaque data type to be removed | Must be an existing distinct or opaque type in the local database; cannot be a built-in data type | Identifier;
Data Type |
| owner | Name of data type owner | Must own the data type | Owner Name |
To drop a distinct or opaque data type with the DROP TYPE statement, you must be the owner of the data type or have the DBA privilege. When you use this statement, you remove the data type definition from the database (in the sysxtdtypes system catalog table). In general, this statement does not remove any definitions of casts or of support functions associated with that data type.
You cannot drop a distinct or opaque type if the database contains any casts, columns, or user-defined functions whose definitions reference the data type.
The following statement drops the new_type data type:
DROP TYPE new_type RESTRICT
Related statements: CREATE DISTINCT TYPE, CREATE OPAQUE TYPE, CREATE ROW TYPE , DROP ROW TYPE , and CREATE TABLE