|
Synonyms or Aliases are different names that point to existing 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
In the Oracle Synonym Editor, you select a Schema, Object Type and the actual Object.
See also: MS SQL Synonym Editor