create-a-new-database-diagram-visual-database-tools.md

title	Create a New Database Diagram
ms.custom	seo-lt-2019
ms.date	09/24/2018
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	ssms
ms.topic	conceptual
helpviewer_keywords	diagrams [SQL Server], creating database diagrams [SQL Server], creating
ms.assetid	843649c0-10bb-4b6a-9369-6b10733381e9
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer

Create a New Database Diagram (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md] You can use Object Explorer to create new database diagrams. Database diagrams graphically show the structure of the database. Using database diagrams you can create and modify tables, columns, relationships, and keys. Additionally, you can modify indexes and constraints.

To create a new database diagram

1. In Object Explorer, right-click the Database Diagrams folder or any diagram in that folder.

2. Choose New Database Diagram on the shortcut menu.

   The Add Table dialog box appears.

3. Select the required tables in the Tables list and click Add.

   The tables are displayed graphically in the new database diagram.

You can continue to add or delete tables, modify the existing tables, and alter table relationships until the new database diagram is complete.

See Also

Work with Database Diagrams (Visual Database Tools)
Understand Database Diagram Ownership (Visual Database Tools)