Deletes a synonym.
DROP [PUBLIC] SYNONYM [schema.]syn_name
You can use the
DROP SYNONYM command to delete existing synonyms. To run this command on a synonym, you must be
the owner of the synonym and have the
USAGE privileges on the schema in which the synonym resides.
Similar to other objects that can be schema-qualified, you may have two synonyms with
the same name in your search path. To disambiguate the name of the synonym to be dropped,
include a schema name. Unless a synonym is schema-qualified in the
DROP SYNONYM command, PolarDB databases compatible with Oracle deletes the first instance of the
synonym that is found in your search path.
You can optionally add the
PUBLIC clause to drop a synonym that resides in the public schema. The
DROP PUBLIC SYNONYM command is compatible with Oracle databases and drops a synonym that resides in the
DROP PUBLIC SYNONYM syn_name;
The following example drops the personnel synonym:
DROP SYNONYM personnel;