DROP TYPE v15
Name
DROP TYPE
— Remove a type definition.
Synopsis
Description
DROP TYPE
removes the type definition. To execute this command, you must be a superuser or the owner of the type.
The optional BODY
qualifier applies only to object type definitions, not to collection types or to composite types. If you specify BODY
, only the object type body is removed and not the object type specification. If you omit BODY
, both the object type specification and body are removed.
The type isn't deleted if other database objects depend on the named type.
Parameters
name
The name of a type definition to remove.
Examples
Drop the object type named addr_obj_typ
:
Drop the nested table type named budget_tbl_typ
: