How to remove tables from a 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.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?