DROP SYNONYM
Function
DROP SYNONYM deletes a synonym.
Precautions
The owner of SYNONYM or a user granted with the DROP ANY SEQUENCE permission can run DROP SYNONYM. The system administrator has this permission by default.
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