Chat now with support
Chat with Support

Toad Data Modeler 6.2 - 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

Move Entities

Models and Model Objects > Physical Data Model > Entity Relationship Diagram Objects > Move Entities

In Toad Data Modeler there are several methods to move entities. You can select from the following options.

To move entities on a Workspace, use

  • Drag&Drop techniques

or

  • Keyboard arrows

TIP:

  1. Select Settings | Options | Graphics | Move Objects by (mm/10) to set the size of a step to move (in tenths of millimeters).
  2. Select an entity, press SHIFT, hold it down and use the keyboard arrows to change size of the entity box.

To move multiple entities at once

  1. Make multiple selection of entities (see Select Objects for more information).
  2. Point your mouse cursor at any of the selected entities, click and hold the mouse button down.
  3. Drag the objects to the required position and drop. All selected entities will be moved there, including their relationships.

To move entities to another Workspace or another model, select from the following options:

  • Cut&Paste functions: Edit | Cut/Paste, or via shortcuts CTRL+X, CTRL+V
  • Drag&Drop techniques between the Entities dialogs of two different models
  • Drag&Drop techniques between the Entities dialog and Model Explorer
  • Drag&Drop techniques in or from Model Explorer
  • Drag&Drop techniques between Entities dialog/Model Explorer and Workspace

Example: Moving an entity from Model A to Model B using Model Explorer:

Method 1: Moving an entity between Model Explorers of the two models.

  1. Open Model Explorers in both models. You may want to undock at least one of the Model Explorer windows.
  2. Select an entity in Model Explorer A and hold the mouse button down.
  3. Drag the entity to the Entities folder in the Model Explorer B and drop.

Version B: Moving an entity from Model Explorer A directly to a Workspace of Model B.

  1. Undock the Model Explorer A if it's docked, and click the Workspace tab of Model B in the Application Window.
  2. Select an entity in Model Explorer A and hold the mouse button down.
  3. Drag the entity to a Workspace of Model B and drop.

Entity Right-Click Options

Models and Model Objects > Physical Data Model > Entity Relationship Diagram Objects > Entity Right-Click Options

Right-click the selected entity on the Workspace to see the following options:

Option Description

Format

Opens the Object Format dialog for the selected entity.

Add into Workspace

Opens the Workspaces dialog where you can select a Workspace to add the entity to.

Add into New Workspace

Creates a new Workspace and adds the entity to it.

Remove from Workspace

Removes the selected shortcut from particular Workspace.

Delete Object

Deletes selected entity from model.

Arrange

Arranges the entity in another layer.

Arrange Objects in Layers

Add Object to Gallery Adds objects to selected Gallery.

Recalculate Size

Adjusts the entity size to the length of its columns.

Align Self Relationship

Aligns self relationship.

Edit

Opens the Entity Properties form.

Add Creates a new object (Attribute, Key or Index) in the selected entity.
Change Script Contains one option that allows you to compare selected entity with any other entity in another model or database and generate Change Script.
Edit Attribute... Opens Attribute Properties form (the item is active if attribute is selected)
Select  
Select Parent Objects Selects parent objects of the selected entity on Workspace.
Select Child Objects Selects child objects of the selected entity on Workspace.
Select Parent and Child Objects

Selects parent and child objects of the selected entity on Workspace.

TIP: Use these options for next multiple copy, move, format change etc.

Fill  

Fill Parent Objects

Displays shortcuts of parent objects of the selected entity on Workspace.

Fill Child Objects

Displays shortcuts of child objects of the selected entity on Workspace.

Fill Parent and Child Objects

Displays shortcuts of parent and child objects of the selected entity on Workspace.

Add to Category Adds object to selected category.
Macros Shows available macros for the selected entity.
 

Attributes

Create Attributes

Models and Model Objects > Physical Data Model > Basic Database Design > Create Attributes

You can create attributes in:

  • Entity right-click menu on Workspace
  • Entity Properties dialog
  • Attribute Properties dialog
  • Model Explorer

To create an attribute on the Workspace

Right-click an entity on the Workspace and select Add | Attribute. The Attribute Properties dialog opens.

Note: Select the Primary Key (Unique) checkbox to set the attribute as PK or unique attribute.

To create an attribute in the Entity Properties form

  1. Double-click an entity on Workspace.
  2. In the Entity Properties form, switch to the Attributes tab and click Add.

Entity Properties attribute columns

Column/Option Description

Key

Graphical representation of keys of a particular attribute

Caption

Logical attribute name

Name

Physical attribute name

Data Type

Data Type of an attribute

TIP: You can set a default data type for newly created attributes. See Settings Menu | Options | Physical Model | *database platform and version* | Default Data Type combo-box. (The selected data type will be also applied to Dictionary Types and Domains.)

p1

Parameter 1. Only some of the available data types have this parameter. Defines properties of the selected data type, e.g. length in case of the Char data type.

p2

Parameter 2. Only some of the available data types have two parameters. E.g. the Decimal data type has two parameters, which define precision and scale.

Not Null

When checked, the attribute cannot be empty.

Comments

Comments or descriptions related to the attribute

Status

Shows status of attributes in grid. Status of Items in Grids

Buttons:

- opens the Application Variables form

Smaller Add button- adds new attributes quickly, just enter attribute name and then click Add.

Bigger Add button - adds an attribute

Edit - opens Attribute Properties of the selected entity

Delete - deletes the selected attribute

- moves the selected attribute up or down in the list

To create another attribute in the Attribute Properties form

Click OK+Add.

To create an attribute in Model Explorer

Unfold the Entities folder | Unfold the specific entity folder | Right-click the Attributes folder | Add Attribute.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating