Aqua Data Studio provides visual editors for creating Aliases and Synonyms.
Alias
An alias is an alternative name for a database object for use in SQL scripts and queries.
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.
1. Connect to Server | 2. Right Click on Aliases | 3. Name Alias Select Object | 4. Preview Alias SQL |
DROP Alias
Right-clicking on an alias allows it to be dropped.
Synonym
A synonym is a name that translates into another name whenever it is referenced. In other words, we can say that a synonym is an alternative name for a database object.
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.
DROP Synonym
Right-clicking on a Synonym allows it to be dropped through the Schema Browser.