Procedure documentationRenaming Synonyms Locate this document in the navigation structure

Prerequisites

  • You are logged on to the database as a database user.

  • The current database user created the synonym.

  • The database is in the ONLINE operational state.

Procedure

  1. Select the synonym in the explorer tree.

  2. In the context menu of the synonym, choose Definition.

  3. In the context menu of the editor window, choose Edit.

  4. Change the name of the synonym.

  5. In the context menu of the editor window, choose Alter Synonym.

More Information

SQL Reference Manual, RENAME SYNONYM Statement (rename_synonym_statement)