Page History
...
To create an Alias, connect to a server. Expand the Schema tree and right-click on the Aliases container and select Create Alias. Enter the Alias name and select the schema and object. Preview the Alias SQL in the Preview SQL tab. Click ok to finish. Alias schema objects are only available for specific DB2 databases and versions.
DROP Alias
Right-clicking on an alias allows it to be dropped.
...
To create a Synonym, connect to a server. Expand the Schema tree and right-click on the Synonyms container and select Create Synonym. Enter the Synonym name and select the schema and object. Preview the Synonym SQL in the Preview SQL tab. Click ok to finish. Synonym schema objects are available for Oracle and Microsoft SQL Server.
|
|
|
| |||
| 1. Connect to Server | 2. Right-click on Synonyms | 3. Name Synonym Select Object | 4. Preview Synonym SQL |
ALTER Synonym
Synonyms may be altered through a right-click in the schema browser.
...