You can update the alias for a table reference
in an SQL statement
in the SQL Query 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 Query Builder.
To
update the alias for a table reference in an SQL statement
in the SQL Query 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.