A script-enabled browser is required for this page to function properly.

Identifying a renamed table (Query Builder)

In a stored query, it is not immediately apparent whether a particular table has a user-defined name or its original name.

To find out if a particular table has been renamed:

  1. Click the Rename Table icon in the Icon Bar.
  2. Click the table in question in the list of Available Tables.

If the table has been renamed, the alias name appears in the New Name: field and a different name (the original table name) in the Default Table Name: field.

SQL users can also identify renamed tables by clicking the Show SQL button in the Icon Bar to display the Show SQL dialog box, where any name changes appear in the SELECT statement in standard SQL syntax for table aliases. 

See also

Renaming a table (Query Builder)

Defining a query using Query Builder