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.


Parameter Description
syn_name syn_name is the name of the synonym. A synonym name must be unique within a schema.
schema schema specifies the name of the schema where 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 O Edition 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 PolarDB-O databases and drops a synonym that resides in the public schema:


The following example drops the personnel synonym:

DROP SYNONYM personnel;