Create a New Database Diagram (Visual Database Tools)

• 09/24/2018
• 2 minutes to read
• •  
  •  
  •  
  •  
  •  

  • +1

In this article

1. See Also

Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Parallel Data Warehouse

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)

Is this page helpful?

 Yes  No

Recommended content

• Open Database Diagrams - Visual Database Tools

  Open Database Diagrams (Visual Database Tools)

• Work with Database Diagrams - Visual Database Tools

  Work with Database Diagrams (Visual Database Tools)

• Open Database Diagram Designer - Visual Database Tools

  Open Database Diagram Designer (Visual Database Tools)

• Create Relationships Between Tables on a Diagram - Visual Database Tools

  Create Relationships Between Tables on a Diagram (Visual Database Tools)