A synonym is an alternate name for a database object that lets you:
● Reference an object without specifying its owner (The synonym definition references the owner, but to use the synonym thereafter you do not have to know the owner name.)
● Reference a remote object without specifying its database.
● Alias an object so its purpose becomes more obvious.
The following database platforms support Synonyms:
● IBM DB2 for OS/390 5.x and 6.x and for z/OS 7.x, 8.x, 9.x, and 10x
● Microsoft SQL Server 2005, 2008, and 2012
● Oracle 8.x, 9i, 10g, and 11g
Note: The Synonym Wizard and Synonym Editor share the same options, except for Attachment Bindings options which are present only in the editor.
Create a Synonym
1. In the Data Model Explorer, expand the Physical Main Model, right-click the Synonyms node, and then select New Synonym.
2. Complete the Synonyms Wizard and then click Finish to create the synonym.
Tip: Once you have created the synonym, you can edit it by right-clicking the synonym you want to change, and then clicking Edit Synonym.
The following helps you complete the options of the Synonyms Wizard:
|
Note: The options available depend on the database platform selected.