Removing Input Sources

See Also

You can remove an input source if you no longer need that input source as part of your query.

Note   Removing an input source does not delete the underlying table from the database; it only removes the input source 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 an input source

• In the Diagram pane, select the input source, and then press DELETE, or right-click the input source and then choose Remove. You can select and remove multiple input sources at one time.

  –or–

• Remove all references to the input source in the SQL pane.

When you remove an input source, the Query Designer automatically removes joins that involve that input source and removes references to the input source’s data columns in the SQL and Grid panes. However, if the query contains complex expressions that involve the table, the table name is not automatically removed until all references to the table are removed.