—
NAME
DROP_TYPE - remove a data type
SYNOPSIS
bash
DROP TYPE [ IF EXISTS ] \nname\n [, ...] [ CASCADE | RESTRICT ]DESCRIPTION
DROP TYPE removes a user-defined data type. Only the owner of a type can remove it.
PARAMETERS
IF EXISTS
name
CASCADE
RESTRICT
EXAMPLES
To remove the data type box:
bash
DROP TYPE box;COMPATIBILITY
This command is similar to the corresponding command in the SQL standard, apart from the IF EXISTS option, which is a PostgreSQL extension. But note that much of the CREATE TYPE command and the data type extension mechanisms in PostgreSQL differ from the SQL standard.
SEE ALSO
ALTER TYPE (ALTER_TYPE(7)), CREATE TYPE (CREATE_TYPE(7))