Creating Aliases & Synonyms

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