Easily find issues by searching: #<Issue ID>
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam
Aqua Data Studio provides visual editors for creating Aliases and Synonyms.
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.
Right clicking on an alias allows it to be dropped.
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.
Synonyms may be altered through a right click in the schema browser.
Right clicking on a Synonym allows it to be dropped through the Schema Browser