remove-tables-from-database-diagrams-visual-database-tools.md

title	Remove Tables from Database Diagrams
ms.custom	seo-lt-2019
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	ssms
ms.topic	conceptual
helpviewer_keywords	deleting tables removing tables dropping tables
ms.assetid	11afcfa1-816b-419c-9bc7-3abf366f4c3c
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer

Remove Tables from Database Diagrams (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] You can remove a table from your database diagram. Removing a table does not alter your database. The table and its relationships to other tables continue to exist in the database.

To remove a table from a database diagram

1. In your database diagram, select the table you want to remove.

2. Right-click the table and choose Remove Table from Diagram from the shortcut menu.

   -or-

   Press the ESC key.

   If the table has unsaved changes as a result of edits you made in the database diagram, a message prompts you to save the table before removing it.

The table is removed from your diagram but it continues to exist in the database.

See Also

Work with Database Diagrams (Visual Database Tools)
[How to: Delete Tables from a Database(https://msdn.microsoft.com/ca6aa3e9-9885-44c3-bafc-aec441fd97ec)