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, case of other letters will not be changed.
Lower – All letters in the name of an entity are converted to lower case.
Upper – All letters in the name of an entity are converted to upper case.
Remove Prefix(es) – Removes specified prefix(es).
Remove Suffix(es) – Removes specified suffix(es).
Add Prefix – Adds specified prefix.
Add Suffix – Adds specified suffix.
Pluralization
Unchanged – Does not change the number.
Singularize – Singularizes entities or entity members’ name.
Pluralize – Pluralizes entity or entity members’ name.
Remove underscore – Select this checkbox 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.