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;