Online Documentation for SQL Manager for DB2

Creating/editing alias


Use the Alias tab of Alias Editor to create/edit an alias and specify its definition.

 

Alias Editor - Editing alias definition

 

 

Alias schema

Use the drop-down list to select the schema for the new alias.

 

Alias name

Enter a name for the new alias. The name must not identify a table, view, nickname, or alias that exists in the current database.

 

Object type

Select the object type to define the alias for: Table, View, Nickname, Alias for all server versions and MQTable, Module, Global temporary table, Sequence for server version 9.7.

 

Object properties

 

Object schema

Use the drop-down list to select the schema where the object is located.

 

Object name

Use the drop-down list to select the object to define the alias for.