DROP TYPE v16

Name

DROP TYPE Remove a type definition.

Synopsis

DROP TYPE [ BODY ] <name>

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 TYPE addr_obj_typ;

Drop the nested table type named budget_tbl_typ:

DROP TYPE budget_tbl_typ;

See also

CREATE TYPE, CREATE TYPE BODY