Defining Table Aliases

Aliases are alternate names that can make cryptic table names clearer. For example, you can change a table name such as GETLIST.EMP to EMPLOYEES.

*  To define a table alias:

  1. Select a table on the Query Builder - Tables page.

    • Click the table under Selected Tables and click Edit button.

    • Right-click the table under Selected Tables and select Edit.

    • Double-click the table under Selected Tables.

  2. In the Define Table Alias dialog box, enter an alias for the table and click OK.

  3. Enter an alias and click OK.

    The table alias is displayed under Selected Tables with the original table name to the right. For example, EMPLOYEES (GETLIST.EMP).

    To delete a table alias, right-click the table and select Delete Alias.