Postgres Plus Advanced Server Oracle Compatibility Developer's Guide :

Previous PageTable Of ContentsNext Page

3.3.41 DROP TYPE

Name

DROP TYPE -- remove a type definition

Synopsis

DROP TYPE name

Description

DROP TYPE removes the type definition. To execute this command you must be a superuser or the owner of the type. The type will not be deleted if there are other database objects dependent upon the named type.

Parameters

name

The name of a type definition to remove.

Examples

Drop object type addr_obj_typ.

DROP TYPE addr_obj_typ;

Drop nested table type budget_tbl_typ.

DROP TYPE budget_tbl_typ;

See Also

CREATE TYPE

Previous PageTable Of ContentsNext Page