DROP TYPE() SQL Commands DROP TYPE()
NAME
DROP TYPE - remove a data type
SYNOPSIS
DROP TYPE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP TYPE removes a user-defined data type. Only the owner of a type
can remove it.
PARAMETERS
IF EXISTS
Do not throw an error if the type does not exist. A notice is
issued in this case.
name The name (optionally schema-qualified) of the data type to
remove.
CASCADE
Automatically drop objects that depend on the type (such as ta-
ble columns, functions, operators).
RESTRICT
Refuse to drop the type if any objects depend on it. This is the
default.
EXAMPLES
To remove the data type box:
DROP TYPE box;
COMPATIBILITY
This command is similar to the corresponding command in the SQL stan-
dard, apart from the IF EXISTS option, which is a PostgreSQL extension.
But note that the CREATE TYPE command and the data type extension mech-
anisms in PostgreSQL differ from the SQL standard.
SEE ALSO
CREATE TYPE [create_type(l)], ALTER TYPE [alter_type(l)]
SQL - Language Statements 2008-09-19 DROP TYPE()
postgresql 8.3.4 - Generated Fri Oct 3 20:25:00 CDT 2008