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.