remove-joins-visual-database-tools.md

title	Remove Joins (Visual Database Tools) | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	ssms
ms.topic	conceptual
helpviewer_keywords	removing joins joins [SQL Server], removing deleting joins
ms.assetid	ccc212a1-fd13-48d6-85e5-5ff310c34bbd
author	stevestein
ms.author	sstein
manager	craigg

Remove Joins (Visual Database Tools)

If you do not want tables to be joined via an inner join or an outer join, you can remove the join between them. For example, you might remove a join that the Query and View Designer has been created automatically between two tables.

Note

Removing a join from a query does not alter the underlying relationship in the database.

If two joined tables are part of your query and you remove all join conditions between them, the resulting query becomes the product of both tables - that is, it becomes a CROSS JOIN.

To remove a join

• In the Diagram pane, select the join line for the join to remove, and then press the DELETE key. You can select and delete multiple join lines at one time.

The Query and View Designer removes the join line and alters the statement in the SQL pane.

See Also

Join Tables Automatically (Visual Database Tools)
Join Tables Manually (Visual Database Tools)
Query with Joins (Visual Database Tools)