Removing Tables

You can remove a table — or any table-structured object — from the query.

Note   Removing a table or table-structured object does not delete anything from the database; it only removes it from the current query. For details about removing a table from a database, see Deleting a Table from a Database Diagram and the Database.

To remove a table or table-structured object

• In the Diagram pane, select the table, view, user-defined function, or query, and then press DELETE, or right-click the object and then choose Remove. You can select and remove multiple objects at one time.

–or–

• Remove all references to the object in the SQL pane.

When you remove a table or table-structured object, the Query Designer automatically removes joins that involve that table or table-structured object and removes references to the object's columns in the SQL and Grid panes. However, if the query contains complex expressions involving the object, the object is not automatically removed until all references to it are removed.

See Also

Adding Tables