How to: Create a New Database Diagram
You can use Server 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.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.
To create a new database diagram
In Server Explorer, right-click the Database Diagrams folder or any diagram in that folder.
Important
You can use the Database Diagram Designer to update databases in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2. However, SQL Server 2012 doesn't support this feature.
Choose Add New Diagram on the shortcut menu.
The Add Table dialog box appears.
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
Concepts
Understanding Database Diagram Ownership