DROP TYPE

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

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

**Table 1** DROP TYPE parameters
Parameter	Description	Value Range
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).	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.

Delete compfoo type.

     
          DROP TYPE compfoo cascade;

Parent Topic: DDL Syntax

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel