Chat now with support
Chat with Support

Toad Data Modeler 6.3 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
About Physical Data Modeling Benefits of Physical Data Model Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects Model Properties Model Statistics
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Projects Reports Reverse Engineering Scripting and Customization SQL Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Supported Databases Connection Types by Database DB2 UDB v. 8 (LUW) DB2 v. 9 (LUW) DB2 v. 9.5 (LUW) DB2 v. 9.7 (LUW) DB2 v. 10.1 (LUW) DB2 v. 10.5 (LUW) DB2 z/OS v. 9 DB2 z/OS v.10 DB2 z/OS v. 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 Microsoft Access 2000/2002/2003 Microsoft Access 2007/2010 Microsoft Azure SQL Database Microsoft Azure SQL Database V12 Microsoft SQL Server 2000 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 Oracle 9i Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 PostgreSQL 8.1 PostgreSQL 8.2 PostgreSQL 8.3 PostgreSQL 8.4 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 SQLite 3.7 Sybase ASE 12.5 Sybase ASE 15 Sybase ASE 15.5 Sybase ASE 15.7 SAP ASE 16.0 Sybase IQ 15.2 Sybase SQL Anywhere 11 SAP SQL Anywhere 17 Teradata 13 Vertica Database 8.0
Legal Information

Rules

Models and Model Objects > Logical Data Model > Rules > 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

  1. Open the Attribute Properties dialog of the selected attribute | Rules tab.
  2. Select a rule and click the Add arrow button.

Note: You can define rules for domains too.

Working with Model Objects

Add Objects

Models and Model Objects > Working with Model Objects > Add Objects

Toad Data Modeler allows you to add objects from multiple places. See the following options:

To add an object on Workspace

  1. Click the object icon on the toolbar, e.g. for entity
  2. Click anywhere on the workspace to add the object.

or

  1. In Objects Menu | Add New select the object you want to add to Workspace
  2. 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

  1. Press SHIFT and click the object icon on toolbar.
  2. Click on workspace as many times as many objects you need to add.
  3. Right-click the work area (or click the object icon again) to turn this function off.

To add objects to Model Explorer

  1. 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

  1. Select Model | Model Items | and the object type (e.g. Entities).
  2. In following dialog click the Add button.  

Edit Objects

Models and Model Objects > Working with Model Objects > 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

  1. Select an object on Workspace or in Model Explorer.
  2. Select Objects Menu | Edit

To edit objects from Model menu

  1. Select Model Menu | Model Items | the object type (e.g. Entities).
  2. In the dialog (Entities), select the object and click Edit.

Buttons in Object Properties dialogs:

- 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:

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating