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.
Prerequisite: The SQL statement
must
be open in the SQL Query Builder.
About this task
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.