Removes a data type.
DROP TYPE [IF EXISTS] <name> [, ...] [CASCADE | RESTRICT]
DROP TYPE
will remove a user-defined data type. Only the owner of a type can remove it.
Remove the data type box
;
DROP TYPE box;
This command is similar to the corresponding command in the SQL standard, apart from the IF EXISTS
option, which is a Greenplum Database extension. But note that the CREATE TYPE
command and the data type extension mechanisms in Greenplum Database differ from the SQL standard.
Parent topic: SQL Command Reference