DROP TYPE

Function

DROP TYPE deletes a user-defined data type. Superuser, sysadmin and the owner of a type has the DROP TYPE permission.

Syntax

DROP TYPE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

Parameter Description

• IF EXISTS

  Reports a notice instead of an error if the specified type does not exist.

• name

  Specifies the name (optionally schema-qualified) of the type to be deleted.

• CASCADE

  Automatically deletes the objects (such as fields, functions, and operators) that depend on the type.

  RESTRICT

  Refuses to delete the type if any objects depend on it. This is the default action.

Example

See Examples in CREATE TYPE.

Helpful Links

CREATE TYPE and ALTER TYPE