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

name

CASCADE

RESTRICT

EXAMPLES

To remove the data type box:

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