On this tab of the Model Settings window you can set naming rules for database objects and their members to be added to the database.
The Database Naming page is divided in two sections - Table and Procedure Names and Table Columns' Names. The options presented in both sections allow to change the names of database objects and their members by adding or removing suffixes, prefixes etc.
Case
Changes the case of the letters in the name. Can take the following values:
Unchanged
Does not change the case.
Capitalized
The first letter of the entity name and the first letter after each underscore in the table name will be uppercase, other letters will be lowercase.
FirstLetterUppercase
The name of an entity begins with a capital letter, the case of other letters will not be changed.
Lower
All letters in the name of an entity are converted to the lower case.
Upper
All letters in the name of an entity are converted to the upper case.
Remove Prefix(es)
Removes the specified prefix(es).
Remove Suffix(es)
Removes the specified suffix(es).
Add Prefix
Adds the specified prefix.
Add Suffix
Adds the specified suffix.
Pluralization
Unchanged
Does not change the number.
Singularize
Singularizes the entities or entity members' name.
Pluralize
Pluralizes the entity or entity members' name.
Remove underscore
Select this check box to remove underscores from the names of the generated tables, views, and columns.
In the Example section, the current and expected names are shown in the corresponding Original and Becomes fields.