You can update the alias for a table reference in an SQL statement
in the SQL builder.
Table references are objects such as tables and views that you
can include in an SQL statement.
Prerequisite: The SQL statement
must be open in the SQL builder.
To update the alias for a table reference in an SQL statement
in the SQL builder:
- Right-click the table reference in the Tables pane, and then click Update
Alias on the pop-up menu.
- In the Change Table Alias window, type an alias and then click OK.
In the Tables pane, the name in the header of the table graphic shows
the new alias.