Help Center/ GaussDB/ Developer Guide(Centralized_8.x)/ SQL Reference/ SQL Syntax/ D/ DROP TYPE
Updated on 2024-06-03 GMT+08:00
View PDF
Share

DROP TYPE

Description

Deletes a user-defined data type.

Precautions

Only the owner of a type, a user granted the DROP permission on a type, or a user granted the DROP ANY TYPE permission on a sequence can run the DROP TYPE command. When separation of duties is disabled, a system administrator has this permission by default.

Syntax

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

Parameters

  • 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 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 action.

Examples

See Examples in section "CREATE TYPE."

Helpful Links

CREATE TYPE and ALTER TYPE

Parent topic: D