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.

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:

  1. Right-click the table reference in the Tables pane, and then click Update Alias on the pop-up menu.
  2. 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.
Related tasks
Adding table references to SQL statements in the SQL Query Builder

Feedback