Setting Diagram Options

Last modified: November 2, 2023

A database diagram can be tuned with a rich set of options. Options can be set either globally for all the diagram documents or separately for a particular one.

To set options for the current diagram, right-click it and choose Options from the shortcut menu to open the Diagram Options dialog box. You can reset options for the current diagram to default values (set globally) by using the Default button.

Changing Diagram Appearance

You can use either IDEF1X or IE notation for relations. They can be switched by using the Relation Notation drop-down list.

With the notations options you can greatly customize the table shape look. You may hide its constraints, indexes, and triggers compartments, change its field detail level to display only column names, names with types or names with full types. Note that field detail level does not affect stored routines. Primary key columns may either be separated with horizontal line or placed with other columns.

On the General page of the Database Diagram section of Options Dialog Box you can customize diagram background color, shape shadows, and diagram grid.

Setting Diagram Printing Options

Page options allow you to set such page settings as orientation (portrait or landscape), paper size and source, printing margins and overlapping, header and footer text.

Print options allow setting parameters for positioning printed image in the center, diagram scale, and whether to print diagram grid. Diagram scale may be set either manually, using Scale field, or automatically to fit the desired number of pages. They also allow you to set up printing of the page markup that helps you to glue diagram pages together.