DROP TYPE
Function
DROP TYPE deletes a user-defined data type.
Precautions
The owner of a type, a user granted the DROP permission for a type, or a user granted the DROP ANY TYPE permission on a type can run the DROP TYPE command. The system administrator has this permission by default.
Syntax
DROP TYPE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
Parameter Description
IF EXISTS
Reports a notice instead of an error if the specified type does not exist.
name
Specifies the name (optionally schema-qualified) of the type to be deleted.
CASCADE
Automatically deletes the objects (such as fields, functions, and operators) that depend on the type.
RESTRICT
Refuses to delete the type if any objects depend on it. This is the default action.
Examples
See Examples in CREATE TYPE.
Helpful Links
Feedback