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
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