Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Ilakshi Rathod : "This tool is just wonderful. I have never seen any tool for DB2. This tool provides very good features which helps in ease us work as well as quick resolution of any errors.".
Jeff Rule: "I have to tell you I am really impressed. I have never had a software company turn around a bug fix like this so fast. I have been doing database work for over 20 years and that has never happened.".

More

Add your opinion

Customers
SQL Maestro Group / Products / DB2 / DB2 Maestro / Documentation
Download Buy

DB2 Maestro online Help

Prev Return to chapter overview Next

Specifying alias options

Specify alias options according to your needs.

 

Name

Specify a name for the alias. The name must not identify a table, view, nickname, or alias that exists in the current database. If a two-part name is specified, the schema name cannot begin with ’SYS’. The rules for defining an alias name are the same as those used for defining a table name.

 

Comment

Specify a comment to the alias or leave the field blanc.

 

Object name

Specify the base object that the alias references. Select from drop-down list a table, view, nickname, or alias for which alias-name is defined. If another alias name is supplied (alias-name2), then it must not be the same as the new alias-name being defined (in its fully-qualified form). The table-name cannot be a declared temporary table.



Prev Return to chapter overview Next