Display Preferences editor allow you to change the look of the diagram, control the number of object attributes to show in the diagram and define diagram grid displaying and behavior. 

To access to the Display Preferences editor, select the Tool | Display Preferences item menu.

General

On this tab you can set diagram workspace color, define grid parameters and enable page delimiters displaying.

 

Workspace Color

Use this option to set a background color of the diagram. Choose the color you need from this drop-down list. 

 Show Page Delimiter

Makes page delimiters visible on the diagram. This helps you to understand how the diagram will be disposed on the physical pages.

Snap to Grid

Enables snapping of objects to the grid. If you enable it, when you move the table or other object, its upper left corner "snaps" to the nearest grid point.

Show Grid

Shows grid in your diagram.

Size

Use this option to change the interval between grid points. 

Table

This tab allows you to define table attributes to show in the diagram and set the default colors for the new tables. See Notation section to find out what are table parameters mean. Note, that you can change some display parameters for a particular table using Formatting Table editor.

 

Columns

Enables displaying table columns on the diagram.

Indexes

Enables displaying table indexes on the diagram.

Data types

Enables displaying data type near a table column.

Domains

Show domain name near a domain-based table column.

Index indicator

Shows availability of index for a column.

NULL/NOT NULL indicator

Shows NOT NULL column attribute status.

Foreign key indicator

Shows availability of foreign key for a column.

Fill Color

Use this option to set a background color of the table. Choose the color you need from this drop-down list. 

Line Color

Use this option to set a border color of the table. Choose the color you need from this drop-down list. 

Reference

This tab allows you to set the reference display preferences. Note, that you can apply some changes to a particular reference using Reference Editor.

 

Constraint Name

This option enables displaying of the reference name box in the middle of the reference.

Cardinality

This option enables displaying of the reference cardinality.

Join

This option enables displaying of table columns used in the reference join.

Notation

Use this drop-down list to select reference notation style:

• Relational. This notation shows a reading direction for references.
• Conceptual (Crows Foot). This notation consist of the splitting of a line into an approximation of the cardinality

Reference Line Color

Use this option to set a diagram references color. Choose the color you need from this drop-down list.  

Reference Labels Color

Use this option to set a color of join label. Choose the color you need from this drop-down list.  

Default On Update Action

Choose an On Update action that will be set for new references. 

Default On Delete Action

Choose an On Delete action that will be set for new references. 

Stored Routines 

This tab allows you to set the display preferences of stored procedures and functions. Note, that you can apply some changes to a particular stored procedure using Stored Routine Editor.

 

Fill Color

Use this option to set a default background color of a stored routine. Choose the color you need from this drop-down list. 

Line Color

Use this option to set a default border color of a stored routine. Choose the color you need from this drop-down list. 

Views

This tab allows you to set the display preferences of views. Note, that you can apply some changes to a particular view using View Editor.

 

Fill Color

Use this option to set a default background color of a view symbol. Choose the color you need from this drop-down list.  

Line Color

Use this option to set a default border color of a view. Choose the color you need from this drop-down list. 

 

Diagram: Using Snapping Grid | Notation

 

 

---

©2005 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.