Updating aliases for table references in SQL statements in the SQL builder

You can update the alias for a table reference in an SQL statement in the SQL 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 builder.

To update the alias for a table reference in an SQL statement in the SQL 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 builder

Feedback