DROP TYPE
Name
DROP TYPE
-- remove a user-defined data type
Synopsis
DROP TYPE typename [, ...] [ CASCADE | RESTRICT ]
Inputs
- typename
The name (optionally schema-qualified) of an existing type.
- CASCADE
Automatically drop objects that depend on the type
(such as table columns, functions, operators, etc).
- RESTRICT
Refuse to drop the type if there are any dependent objects.
This is the default.
Outputs
- DROP TYPE
The message returned if the command is successful.
- ERROR: RemoveType: type 'typename' does not exist
This message occurs if the specified type is not found.
Description
DROP TYPE will remove a user type from the
system catalogs.
Only the owner of a type can remove it.
Examples
To remove the box type:
DROP TYPE box;
Compatibility
Note that the CREATE TYPE command and the data
type extension mechanisms in PostgreSQL
differ from SQL99.