You can update the alias for a table reference in an SQL
statement in the SQL Query Builder.
Before you begin
Table references are objects such as tables and views that
you can include in an SQL statement.
The SQL statement
must be open in the SQL Query Builder.
Procedure
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.
Results
In the Tables pane, the name in the header of the table graphic
shows the new alias.