¶
9.2.3. DROP TYPE Statement
DROP TYPE type_name
This statement reverses the effect of CREATE TYPE statement. If the type has methods defined they are deleted as well. Note that forward references cannot be dropped by a DROP TYPE.
The DROP TYPE statement can be used only for dropping types that are not referenced in another type's UNDER statement.
Example 9.5. Dropping a user-defined type
Dropping the subtype from the previous section.
drop type UDT_TEST_SUB;