Create a New Database Diagram (Visual Database Tools)

Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Analytics Platform System (PDW)

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)