Removing Tables from Query

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

To remove a table or table-structured object

  • In the Diagram Pane, select a table, view, function, synonym, or query, and then press DELETE, or right-click the object and then click Remove from the diagram. You can select and remove multiple objects at one time.

Alternatively

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

When you remove a table or table-valued object, the Query Builder automatically removes joins that involve that table or table-valued object and removes references to the object’s columns in the SQL editor.

Note
Removing a table or table-valued object does not delete anything from the database, it only removes it from the current query.