Toad Data Modeler offers you the possibility of synchronizing and verifying objects Name/Caption in various Properties dialogs as you type. This behavior is controlled by two options located in Naming Convention Properties | General tab.
When neither option is enabled, you can change an object Caption but its Name won't change automatically. To synchronize Name/Caption manually, click the button.
The object Name will be changed to match the Caption as you type.
Similar to Example 1, Name won't be automatically updated. Additionally, naming convention rules and glossary replacements will be applied when performing manual synchronization.
The object Name will be changed to match the Caption as you type, naming convention rules and glossary replacements will be applied to the Name as you type as well.
Naming Convention Verification and Synchronization can be accessed from:
The verification and synchronization process allows you to do two things to multiple objects at once:
Names that do not pass verification or synchronization check can be automatically updated by applying the suggested Name modification. To update such Names, simply check the listed violations/suggestions and click on Update.
Note: The behavior of verification and synchronization process is heavily influenced by Naming Convention Properties.
To show/hide Naming Convention Violations () or Synchronization violations (), use the buttons on the toolbar.
Note: You can disable Verification/Synchronization checking for particular items by clicking the violation (/) icon. This will influence the suggested Name modification.
In the Naming Convention Properties dialog | General tab, you can see options for:
This topic describes how various options affect the Naming Convention Verification and Synchronization process.
Note: Options mentioned in this topic also affect On Form Synchronization behavior.
Description: When enabled, Name/Caption synchronization will be checked during process.
Example: An entity Caption is "Example Entity" and its Name is "ex_entity".
A suggestion will be offered to rename the entity Name so it matches its current Caption - "Example Entity".
Description: When enabled, Naming Convention Rules will be applied and characters/words will be replaced according to Glossary during Name/Caption synchronization.
Example: An attribute Caption is "Customer main ID" and its Name is "Customer ID".
Automatic Synchronization enabled: The suggested Name will be synchronized with the object Caption and then have the NC Rule and Glossary word replacement applied to it - CSTMR MAIN ID.
Automatic Synchronization disabled: The option only affects manual synchronization (see On Form Synchronization for more information).
Description: When enabled, model objects will be automatically verified to see if they don't violate Naming Convention Rules. The verification will occur during Naming Convention Verification and Synchronization process and also when you open Properties dialog of any object.
Example: A relationship Name is "ASSIGNS_orders".
A suggestion will be offered to modify the Name so it matches the rules - "assigns orders".
To Use Glossary for Naming Convention Verification
Description: When enabled, Glossary character and word replacements will be applied during both Automatic Verification and manual verification.
Example: An entity Name is "Entrée kinds"
A suggestion will be offered to modify the Name so it matches the rule and has the defined characters/words replaced - "ENTREE TYPES".
To Turn Case-Sensitivity On