DROP TYPE
Description
Drops a user-defined data type.
Precautions
Only the type owner or a user granted with the DROP permission can run the DROP TYPE command. System administrators have 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 dropped.
- CASCADE
Automatically drops the objects (such as fields, functions, and operators) that depend on the type.
RESTRICT
Refuses to drop the type if any objects depend on it. This is the default action.
Examples
See Examples in "CREATE TYPE."
Helpful Links
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot