|
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. RightClick on
Aliases |
3. Name Alias
Select Object |
4. Preview Alias
SQL |
DROP Alias
Right clicking on an alias allows it to be dropped.
Synonymn
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
|
