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.

Feedback