Synonym Editor

Previous  Top  Next

Synonyms or Aliasses are different names for database objects. They can be very useful if, for example, your target object belongs to a different schema or you want to have a shorter name. The Synonym Editor offers the possibility to create, alter and drop synonyms. If you add or drop a synonym, the Synonyms node in the Database Navigator tree-view will display the change as well by adding or deleting the synonym from the list. Below is an example of the Synonym Editor for Oracle: An Oracle Synonym Editor The Microsoft SQL Server Synonym Editor even allows you to select a whole different server or database for the synonym target object.