Modeling Preferences dialog box (Logical Misc tab)

Use these options to establish the default settings that Microsoft Office Visio uses for all database modeling sessions until new defaults are set.

Propagate on add

Select this check box to create a foreign key relationship when you connect a relationship line between two tables. Selecting this check box creates a new column in the child table and identifies a foreign key relationship between the two tables.

If this check box is cleared, the parent-to-child relationship is created, but the model will not be semantically valid until you modify the relationship to associate the parent with a child column. Then you can create a foreign key relationship with a column of a different name from that of the parent.

Propagate on delete

Select this check box to delete any foreign key column(s) from a child table if the defined foreign key relationship is deleted from the model.

If this check box is cleared, only the relationship is dropped, and any columns specified as foreign keys are left in the child table.

Name conflict resolution

Click the behavior to use when you add a foreign key with the same name as a column that already exists in the child table.

Entity

Type the prefix that is used to form the default conceptual name of a table.

Attribute

Type the prefix that is used to form the default conceptual name of a column.

Table

Type the prefix that is used to form the default physical name of a table.

Column

Type the prefix that is used to form the default physical name of a column.

Type

Type the prefix that is used to form the default name of a type.

Field

Type the prefix that is used to form the default physical name of a field.

Primary key

For the logical model, type the suffix to append to all primary key names.

Foreign key

For the logical model, type the suffix to append to all foreign key names.

Index

For the logical model, type the suffix to append to all index names.

Alternate key

For the logical model, type the suffix to append to all alternate key names.

FK name generation option

Click how foreign key names are automatically generated. The suffix used is the text you enter in the Foreign key box under Default name suffixes.