Open database diagrams (Visual Database Tools)

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

You can open database diagrams to view or edit the diagram's structure.

Open a database diagram

1. In Object Explorer, expand the Database Diagrams folder.

2. Double-click the name of the database diagram you want to open.

   -or-

   Right-click the name of the database diagram you want to open, and then choose Design Database Diagram.

The database diagram is opened in the Database Diagram Designer, from which you can edit the diagram.

Note

Only the owner of the diagram or a member of the db_owner role of the database can open the diagram.

Related content

• Work with database diagrams (Visual Database Tools)
• Understand database diagram ownership (Visual Database Tools)