DROP OPERATOR
Description
Drops an operator object.
Precautions
DROP OPERATOR drops the definition of an operator. To use DROP OPERATOR, you must be the owner of the operator.
Syntax
DROP OPERATOR [ IF EXISTS ] name ( { lefttype | NONE } , { righttype | NONE } ) [ CASCADE | RESTRICT ]
Parameters
- IF EXISTS
Reports a notice instead of an error if the operator does not exist.
- name
Name (optionally schema-qualified) of an existing operator.
- lefttype
Type of the left operand of an operator. If there is no left operand, NONE is used.
- righttype
Type of the right operand of an operator. If there is no right operand, NONE is used.
- CASCADE
Automatically drops objects that depend on an operator (such as views that use the operator), and then drops all objects that depend on those objects.
- RESTRICT
Refuses to drop any object that depends on an operator. This is the default value.
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