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.
Prerequisite: The SQL
statement
must be open in the SQL Query Builder.
About this task
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.