Removing Tables from Query

When you rebuild a query and do not need a table anymore, you have to remove it out of the FROM clause. With Fusion for SQL Server, you can do it visually and quickly.

Removing Tables

To remove a table, do either of these actions:

  • Right-click a table shape caption on the diagram and select Remove from Diagram on the shortcut menu
  • Click a table shape caption and press DELETE.

Note

If you have a table shape on the diagram that does not participate in your query (i.e., with no columns selected), it affects the query results. Be attentive and remove unnecessary tables from the diagram.