Updated on 2023-04-03 GMT+08:00

DROP TYPE

Function

DROP TYPE deletes a user-defined data type. Only the type owner has permission to run this statement.

Syntax

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

Parameter Description

  • IF EXISTS

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

  • name

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

  • CASCADE

    Deletes objects (such as columns, functions, and operators) that depend on the type.

    RESTRICT

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

Examples

Delete the compfoo type:

1
DROP TYPE compfoo cascade;

Helpful Links

ALTER TYPE, CREATE TYPE