Change Caption in Reversed Model (Name Stays Unchanged)
Hello all,
I’m sure you already know that Toad Data Modeler v. 3.4.x has brought a new feature called Naming Conventions. If you haven’t discovered it yet, I’m sure you at least noticed that Caption and Name boxes have been replaced. 
This change relates to the naming conventions.
What are the naming conventions in TDM about?
Very briefly, naming conventions allow you to:
- Define your own rules for physical names of objects – e.g. add prefix or suffix to the names, use only lower case etc.
- Synchronize caption (logical name) and name (physical name) of objects of your model.
- Verify whether the physical names of objects match the naming convention rules. If they don’t, you can decide whether to apply them or not.
Note: Naming conventions always influence physical names, NOT captions. Captions (logical names) can be in various forms as they provide logical information only.
If you want to know more, get some examples, see screenshots etc., please read PDF document that is available at:
http://modeling.inside.quest.com/entry.jspa?externalID=3040&categoryID=159
In this article, I want to focus on the following situation:
You reversed your, let’s say, Oracle 10g model to Toad Data Modeler. Now you want to modify logical names of objects (Caption) and leave physical names (Name) unchanged.
How to do it?
Solution: Create a new naming convention and disable the Automatic Synchronization option. Feel free to modify captions then.
Well, this is a solution said in a few words. Now, let me describe what is necessary to do – step by step.
1. Click on any Workspace of the reversed model to activate it.
Just to check out, edit e.g. the T_CUSTOMER entity. Logical name is T_CUSTOMER and physical name is also T_CUSTOMER. As soon as you start editing the caption, you lose the physical name, which is definitely what you don’t want.
Click Cancel in the Entity Properties form.
Now do the following:
2. Click the Set Up Naming Conventions to Model icon on the toolbar.
3. Create a new naming convention (provided that none exists) or click Add New Naming Convention in the Link Naming Convention Definition to Model dialog.
4. Define a name of the new naming convention (Automatic Synchronization OFF) and click OK.
5. Select the new naming convention and press OK+Edit.
6. In the Naming Convention Properties dialog | General tab, clear the Automatic Synchronization checkbox to turn off the automatic synchronization.
7. Confirm OK.
8. Try to edit the entity again. Change its caption now.
You can write a new logical name, the physical name will stay preserved.
And that’s all. It can’t be easier.
Finally, let me draw your attention to:
• The PDF document again:
http://modeling.inside.quest.com/entry.jspa?externalID=3040&categoryID=159
• and also to flash movies on naming conventions:
http://modeling.inside.quest.com/kbcategory.jspa?categoryID=158
Sort the movies by: Title-Descending Order and see movies 35, 36, 37, 38 and 39.
It’s much quicker to watch the movie than read the long document.
If you have any questions on naming conventions, please do ask us via the Modeling community forum.
Have a successful day.
Regards,
Vladka + TDM Team