How to create a new database diagram in SQL Server Object Explorer

Developers use Object Explorer to create new database diagrams. Database diagrams graphically show the structure of the database. Developers can use diagrams to create and modify tables, columns, relationships, and keys. Additionally, they can modify indexes and constraints. When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to create a new database diagram, they should follow the next steps:

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.

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