Updating aliases for table references in SQL statements in the SQL Query Builder
You can update the alias for a table reference in an SQL statement in the SQL Query Builder.
Before you begin
The SQL statement must be open in the SQL Query Builder.
About this task
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.