Share via


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 Visual Studio Settings.

To create a new database diagram

  1. In Server Explorer, right-click the Database Diagrams folder or any diagram in that folder.

  2. Choose Add New 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

Concepts

Understanding Database Diagram Ownership

Other Resources

Working with Database Diagrams

Understanding Visual Database Tools