In Toad Data Modeler you can use application variables in:
Note: To see where you can use application variables, see Expert Mode Menu | Reference Guide. If a property has Resolve Application Variables attribute, you can use application variables within it (e.g. PEREntity - BeforeScript).
Application variables are usually resolved during SQL script generation.
Application variables can be easily accessed via the which can be found in object properties forms. When you click it, the Application Variable dialog opens and displays available variables and in which properties they are supported.
Syntax 2) is useful in Templates and Default Values. Variables using this syntax will be resolved only during SQL Script/Report generation as opposed to variables with syntax 1) which are resolved immediately after creating an object.
Note: OwnerName, OwnerCaption - Explanation: E.g. For attribute it is an entity, for entity it is a model. It has nothing to do with object Owner/Schema.
Example: Define a new name and caption for relationships of your model.
Caption: <%ParentTableName%> - <%ChildTableName%>
Possibility to define a name for propagated attributes in self-relationships (e.g. via prefix, suffix etc.)
Select Settings | Options | Physical Model | Self Relation Attribute Name/Caption.
Example: Name: FK_<%ParentAttributeName%>, Caption: Foreign <%ParentAttributeCaption%>
You can use some text properties of particular objects in a similar way as application variables.
Example: You want to see your comments in a pop-up window on the Workspace whenever you point your mouse cursor at the entity name. But comments are not displayed this way, only notes. OR You want to generate notes in SQL script.
Possible solution: In the Entity Properties form,
Example: Name is property of entity. It is of widestring data type, so you can use application variable <%Name%>. Author is not property of entity. However, you can use the application variable <%Author%> in entity. - All the application variables that you can use for entity are available in the list.
- Double-click the selected application variable to use it in the box/place where you have your cursor.
- Press Esc to close the dialog.
Sync & Convert Wizard| page Settings and Report Wizard | page Options and the Resolve Application Variables checkbox.
Uncheck the checkbox to compare models/generate report without resolving the application variables.
Check the checkbox to compare models/generate report while resolving the application variables.
Toad Data Modeler allows you to export metadata to Microsoft Excel. Comments, notes and other properties can be modified and the file can be then imported back into Toad Data Modeler.
To export your model to a Microsoft Excel document
To import the data back from a Microsoft Excel document
Select which tables and relationships should be imported.
The following table illustrates the modified properties:
NOTE: Aliases of entities and attributes are in columns “From” or “Attributes” in a format: “Object AS alias” in an exported file