Creating a Database Diagram

To create a database diagram, perform the following steps:

  1. On the File menu, select New, and then click Database Diagram.
  2. Drag database objects from Database Explorer to the diagram. Alternately, right-click a database object, point to Send to, and then click Database Diagram. You can also create new database objects on the diagram using the Diagram toolbar.
  3. You may click the Layout Diagram button on the Layout toolbar to layout diagram for a more convenient view. (Or set the diagram layout manually by dragging shapes and moving the relations. You can also use containers to organize the diagram.)
  4. Add a stamp to the diagram to display company and project names, diagram author, version, date, and copyright. To add a stamp, click the New Stamp button on the Diagram toolbar. To edit stamp fields, double-click them and enter values. You can also add notes to the diagram to describe its objects.
  5. Save the diagram for future use.

To navigate the diagram:

  • Use the scrollbars.
  • Move the mouse while holding the middle mouse button.
  • Use the Diagram Overview window. Drag square visible area on the Diagram Overview window with the mouse.

To display the Diagram Overview window, on the View menu, click Other Windows, and then click Diagram Overview, or press CTRL+V, W.

  • Search diagram shapes.
  • Use the Document Outline window. It contains nodes, representing all shapes on the diagram. They are grouped by containers and by object kinds. Stamps and notes are placed to the Notes kind. Table nodes contains their relations.

You can zoom in and out the diagram to simplify the navigating. To quickly move to the area you need, click the Fit button on the Diagram toolbar, then hold CTRL+SHIFT and select the area you need with mouse pointer.