Rules
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
- Open the Attribute Properties dialog of the selected attribute | Rules tab.
- Select a rule and click the Add arrow button.
Note: You can define rules for domains too.
Working with Model Objects
There are three types of models in Toad Data Modeler:
Model Properties
Select Model | Properties.
| Tab | Description | ||
|---|---|---|---|
| General | General information on the model (project, model, author, company, version etc.) | ||
| Before Script |
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. | ||
| Database Parameters |
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.
| ||
| Naming Convention |
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. |
Model Statistics
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. |
Add Objects
Toad Data Modeler allows you to add objects from multiple places. See the following options:
To add an object on Workspace
- Click the object icon on the toolbar, e.g.
for entity
- Click anywhere on the workspace to add the object.
or
- In Objects Menu | Add New select the object you want to add to Workspace
- Click anywhere on the workspace to add the object
|
|
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
- Press SHIFT and click the object icon on toolbar.
- Click on workspace as many times as many objects you need to add.
- Right-click the work area (or click the object icon again) to turn this function off.
To add objects to Model Explorer
- Find the object group in Model Explorer (e.g. Entities) | right-click and select Add (e.g. Add Entity).
To add objects from Model menu
- Select Model | Model Items | and the object type (e.g. Entities).
- In following dialog click the Add button.
Edit Objects
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
- Select an object on Workspace or in Model Explorer.
- Select Objects Menu | Edit
To edit objects from Model menu
- Select Model Menu | Model Items | the object type (e.g. Entities).
- In the dialog (Entities), select the object and click Edit.
Buttons in Object Properties dialogs:
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:
