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.
