In the SQL Query Builder, you can remove one or more table
references from an SQL statement, depending on the type of statement
that you have created.
Before you begin
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.
The SQL statement must be open in the SQL Query Builder.
Procedure
To remove a table reference from an SQL statement in the
SQL Query Builder:
- Right-click the table reference in the Tables pane, and
then click Remove Table on the pop-up menu.
- Click the table reference in the Tables pane, and then
press Delete.
Results
The table reference is removed from the Tables pane and the
removal is reflected in the code in the SQL Source pane.