Background documentationRENAME SYNONYM Statement (rename_synonym_statement) Locate this document in the navigation structure

 

The RENAME SYNONYM statement (rename_synonym_statement) changes the name of a synonym.

Structure

Syntax Syntax

  1. <rename_synonym_statement> ::=
      RENAME [PUBLIC] SYNONYM <old_synonym_name> TO <new_synonym_name>
    
    <old_synonym_name> ::=
      <synonym_name>
    
    <new_synonym_name> ::=
      <synonym_name>
End of the code.
Explanation

The old synonym name old_synonym_name must have been generated by the current database user.

If PUBLIC is specified, the old synonym must be defined as PUBLIC.

A table of the current database user with the new synonym name (new_synonym_name) must not exist already.