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
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