Background documentationDROP SYNONYM statement (drop_synonym_statement) Locate this document in the navigation structure


The DROP SYNONYM statement (drop_synonym_statement) deletes a synonym (alternative name) for a table name.


Syntax Syntax

  1. <drop_synonym_statement> ::=
      DROP [PUBLIC] SYNONYM [<schema_name>.]<synonym_name>
End of the code.

The specified synonym name must identify an existing synonym of the current database user. The name of the current database user only is permitted as the schema name.

If PUBLIC is specified, the synonym identified by the synonym name must be defined as PUBLIC.

The synonym definition is removed from the set of table name synonyms available to the database user.