A SQL Server database diagram graphically represents a relational model of a SQL Server database. With the Database Diagram Design tool, you can drag database objects from Database Explorer to the diagram and perform the following tasks:
To create a database diagram, perform the steps:
Use either of the following options:
To add database objects to the diagram, use either of the following options:
Drag database objects from Database Explorer to the diagram.
In Database Explorer, right-click a database object and select Send to > Database Diagram on the shortcut menu.
On the diagram toolbar, click the database object you want to create.
Optional: To layout a diagram for a more convenient view, right-click on the diagram and select Layout Diagram on the shortcut menu.
-or-
On the Layout toolbar, select Layout Diagram.
-or-
Set the diagram layout manually by dragging shapes and moving the relations. For more information about how to arrange shapes and layout, see Diagram Shapes and Layout and Organizing Diagram Shapes with Containers.
On the Diagram toolbar, click New Stamp to add a stamp to the diagram to display company and project names, diagram author, version, date, and copyright. To edit stamp fields, double-click them and enter values.
You can also add notes, a new database object, a container, an image either from the shortcut menu of the diagram or from the Diagram toolbar. For more information about other elements you can add to the diagram, see Additional Elements on a Diagram.
Save the changes.
To navigate through the diagram, do the following:
To display the Diagram Overview window:
-or-
You can zoom in and out the diagram to simplify the navigation. To quickly move to the area you need, on the Diagram toolbar, click Fit, then hold CTRL+SHIFT and select the area you need with mouse pointer.
Download a 30-day free trial of dbForge Studio for SQL Server and see all of its rich capabilities for yourself!