Deletes a type definition.

Syntax

DROP TYPE [ BODY ] name

Description

You can use the DROP TYPE command to delete the type definition. To run this command on a type, 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 composite types. If you specify BODY, only the object type body is deleted and the object type specification is not deleted. If you do not specify BODY, both the object type specification and body are deleted.

If other database objects are dependent on the specified type, the type is not deleted.

Parameters

Parameter Description
name The name of a type definition to be deleted.

Examples

Drop the addr_obj_typ object type:

DROP TYPE addr_obj_typ;

Drop the nested table type named budget_tbl_typ:

DROP TYPE budget_tbl_typ;