Drop named row types

To drop a named row type, use the DROP ROW TYPE statement. You can drop a type only if it has no dependencies. You cannot drop a named row type if any of the following conditions are true:

• The type is currently assigned to a table.
• The type is currently assigned to a column in a table.
• The type is currently assigned to a field within another row type.

The following example shows how to drop the person_t type:

DROP ROW TYPE person_t restrict;