Remove tables, views, or functions from a query (ADP)

Note  The information in this topic applies only to a Microsoft Access project (.adp).

You can remove a table, view, or function from a query.

Note   Removing a table, view, or function does not delete anything from the database; it only removes it from the current query.

• In the Diagram pane, select the table, view, or function, 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, view, or function, the Query Designer automatically removes joins that involve that table, view, or function 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.