Online Documentation for SQL Manager for InterBase/Firebird

Database Designer

Automatically open last diagram file

Enable this option to load the last opened diagram file on starting the Database Designer.

 

Visual settings

Model notation

When you work in Database Designer, you can choose one of the following modeling notations:

• Integration DEFinition for Information Modeling (IDEF1X);
• Information Engineering (IE).

The IDEF1X and IE notations use different symbols to represent relationships between entities (and tables).

 

 

Draw PRIMARY KEY fields separately

Separates Primary key fields from other fields with a horizontal line.

 

 

Draw entities icons

Displays icons at the left of each entity header according to its type.

 

 

Draw attributes icons

Displays icons at the left of each attribute according to its type (Primary key, Foreign key, ordinary field).

 

 

Draw only names of entities

Displays only entity headers, fields are hidden.

 

 

Draw FOREIGN KEY name

Displays foreign key names for the corresponding relations.

 

 

Draw page borders

Displays borders of the page on the diagram.

If y

Grid options

Show grid

Displays dots in the diagram area to make the grid visible.

 

Snap to grid

Automatically aligns entities on the form with the nearest grid line. You cannot place an entity in between grid lines.

 

Grid size

Sets grid spacing in pixels along the x- and y-axes. Specify a higher number to increase grid spacing.

 

Style & Color

This section helps you to customize the default view of the diagram objects.

 

Select the Element type from the list: Workspace, Selected item, Table, Relation, Field, Comment and set the required options for it, including color or font properties. Use the Apply to all button to apply  the changes to all elements.

 

---