DROP TYPE(l) SQL - Language Statements (2002-11-22) DROP TYPE(l)
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.
SEE ALSO
CREATE TYPE [create_type(l)]
Page 1 (printed 3/24/03)
