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.

Structure

Syntax Syntax

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

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.