Help Center/ Data Warehouse Service/ SQL Syntax Reference/ SQL Syntax Reference (9.1.0.x)/ DDL Syntax/ Databases, Schemas, and Data Types/ DROP TYPE
Updated on 2026-07-02 GMT+08:00
View PDF
Share

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

Table 1 DROP TYPE parameters

Parameter

Description

Value Range

IF EXISTS

If the specified type does not exist, a message is displayed instead of an error.

-

name

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

Specifies an existing domain type.

CASCADE | RESTRICT

Specifies how to process related data in the dependent object when a delete operation is performed.
  • 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 compfoo type.

1
 
DROP TYPE IF EXISTS compfoo cascade;

Helpful Links

ALTER TYPE, CREATE TYPE

Parent Topic: Databases, Schemas, and Data Types