To add a rule
Select Model | Model Items |Rules and click Add in the Rules dialog.
To edit a rule
Select Model |Model Items | Rules and double-click the selected rule or click Edit.
Note: You can also edit/rename/delete rules in Model Explorer | Rules folder | Right-click the selected rule.
To select a rule for attributes
Note: You can define rules for domains too.
There are three types of models in Toad Data Modeler:
Select Model | Properties.
|General||General information on the model (project, model, author, company, version etc.)|
Whatever you write on the Before Script tab, it will be generated before the generated SQL code.
|After Script||Whatever you write on the After Script tab, it will be generated after the generated SQL code.|
|Description||Notes on the model|
|Naming Convention||Here you can select a naming convention for the model.|
The value in the Length Semantics box shows which default length semantics (BYTE or CHAR) was set in the database for reverse engineering of Oracle database.
Here you can link or unlink a naming convention to/from your model.
Manage Naming Conventions - Opens the Naming Convention dialog (available also from the Tools menu)
Edit Naming Convention - Opens the Naming Convention Properties dialog.
To display details on your model, its Workspaces, objects etc.
Select Model | Statistic....
To change some of the General Information (e.g. model name, author or company)
Select Model | Properties....
TIP: You can also change it via the shortcut of Stamp on the Workspace - just double-click the Stamp.
Toad Data Modeler allows you to add objects from multiple places. See the following options:
To add an object on Workspace
TIP: You can also use hot keys to add some objects, e.g. CTRL+E for entity, CTRL+I for inheritance. See Hot Keys for more information.
To add multiple objects to Workspace
To add objects to Model Explorer
To add objects from Model menu
Toad Data Modeler allows you to edit objects from multiple places. See the following options.
To edit objects on the Workspace
Double-click or Enter the selected object.
To edit objects from Model Explorer
Find the object in tree and double-click it (or right-click | Edit).
Note: Double-clicking in Model Explorer does not highlight the object on the Workspace (WS) but opens the Object Properties dialog instead. To highlight a object on WS, right-click and select Find on Workspace.
To edit objects from Objects menu
To edit objects from Model menu
- opens the Application Variables form
OK - confirms changes, closes the form/dialog
Cancel - cancels changes
Apply- confirms changes, doesn't close the form/dialog
Help - Help navigation
Note: Objects of your model that have the Generate checkbox disabled in their Properties dialogs are displayed in Model Explorer this way: