Preferences Window - Data Naming Standard page

Use this page to set default naming conventions, naming standards, and glossary model files for new database objects and model analysis.
Logical
Specify options for logical data model names. These preferences are used to create default names for new logical data objects and also during model validation if naming standard rules are used.
Separator
Type a character that is used between prime words, class words, and modifiers.
Entity
Specify which naming standard items are mandatory and optional for logical entities. You can add, remove, or reorder items in this list by using the toolbar buttons.
Type
Select Prime Word, Class Word, or Modifier.
Optional
Select a check box next to an item in the Type column to specify that the item is mandatory.
Attribute
Specify which naming standard items are mandatory and optional for logical attributes. You can add, remove, or reorder items in this list by using the toolbar buttons.
Type
Select Prime Word, Class Word, or Modifier.
Optional
Select a check box next to an item in the Type column to specify that the item is mandatory.
Physical - Table/Column
Specify options for physical data model names. These preferences are used to create default names for new physical data objects and also during model validation if naming standard rules are used.
Separator
Type a character that is used between prime words, class words, and modifiers.
Entity
Specify which naming standard items are mandatory and optional for tables. You can add, remove, or reorder items in this list by using the toolbar buttons.
Type
Select Prime Word, Class Word, or Modifier.
Optional
Select a check box next to an item in the Type column to specify that the item is mandatory.
Attribute
Specify which naming standard items are mandatory and optional for columns. You can add, remove, or reorder items in this list by using the toolbar buttons.
Type
Select Prime Word, Class Word, or Modifier.
Optional
Select a check box next to an item in the Type column to specify that the item is not mandatory.
Physical - Others
Specify a naming format for constraints and other objects. These preferences are used to create default names for new physical data objects and also during model validation if naming standard rules are used.
Add Variables
Opens a window so that you can add variables to the object name format.
Show as Example
Shows an example of the naming format in the Example field.
Primary Key
Specify the naming format for primary key constraints.
Foreign Key
Specify the naming format for foreign key constraints.
Check Constraints
Specify the naming format for check constraints.
Unique Constraints
Specify the naming format for unique constraints.
Index
Specify the naming format for indexes.
Trigger
Specify the naming format for triggers.
Example
Shows an example of the naming format that is specified for an object.
Glossary
Specify default glossary models. The glossary models that you specify are selected by default in the Analyze Model wizard.
Add
Opens a window so that you can select a glossary model file that is stored in a data design project.
Remove
Removes the selected glossary model from the list.

Feedback