Removing table references from SQL statements in the SQL builder

In the SQL builder, you can remove one or more table references from an SQL statement, depending on the type of statement that you have created.

Table references are objects such as tables and views that you can include in an SQL statement. You can remove table references at any time while you are working on the statement. When you remove a table reference, any expressions or clauses in the statement that refer to the columns in the table reference are deleted.

Prerequisite: The SQL statement must be open in the SQL builder.

To remove a table reference from an SQL statement in the SQL builder:

The table reference is removed from the Tables pane and the removal is reflected in the code in the SQL Source pane.
Related tasks
Adding table references to SQL statements in the SQL builder

Feedback