DROP SYNONYM
Function
DROP SYNONYM deletes a synonym.
Precautions
Only the owner of a synonym or a system administrator has the DROP SYNONYM permission.
Syntax
DROP SYNONYM [ IF EXISTS ] synonym_name [ CASCADE | RESTRICT ];
Parameter Description
- IF EXISTS
Reports a notice instead of an error if the specified synonym does not exist.
- synonym_name
Specifies the name (optionally schema-qualified) of the synonym to be deleted.
- CASCADE | RESTRICT
- CASCADE: automatically deletes the objects (such as views) that depend on the synonym.
- RESTRICT: refuses to delete the synonym if any objects depend on it. This is the default action.
Examples
See Examples in CREATE SYNONYM.
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