Name Abbreviations

This dialog box is displayed after you click Tools, then Name Abbreviations. You must specify a .csv (comma-separated values) file containing pairs in the following format: string-to-use, string-to-be-changed (with or without a space after the comma). In each pair, the second term is the spelling that is to be changed to the first term in names or parts of names (separated by underscores or spaces) in relational models of the current design after you click OK.

As an example, the following lines in a .csv file cause the strings CUS and CUSTOMER to be changed to CUST:

CUST, CUSTOMER
CUST, CUS

For example, a column named customer_id would be changed to cust_id, and a column named cus_last_name would be changed to cust_last_name. (Thus, the resulting names are not necessarily "abbreviated"; they are just made consistent.)

Select a .csv File: Find the .csv file containing the comma-separated value pairs.

All Objects: Controls whether the name changes are applied to tables, columns, indexes, and views, or only to the types of objects that you specify.

Keep Letter Case: Controls whether the letter case of the current name is retained when the name string is changed. If this option is disabled, any spelling (case) of the name to be changed uses the case as specified in the pair in the .csv file. For example, if this option is disabled and if the string pair is CUST,CUSTOMER, a name of customer_first_name would be changed to CUST_first_name.

Note: Do not confuse "Name abbreviations" with naming standardization, which is wider in scope and is integrated with the checking of Design Rules. Naming standardization is implemented through Data Modeler user options, as explained in Naming Standard.