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

Docking

User Interface > Interface Layout > Docking

Docking means moving an UI element (window, toolbar) to a custom position. This feature allows you to customize the Toad Data Modeler interface to meet your needs and requirements.

You can dock the following UI elements:

  • Big windows (Designer, Script Editor, etc.)
  • Small windows (Message Explorer, Application View, etc.)
    • Model Specific - exists for one model only (Model Explorer)
    • Non-Model Specific - exists across multiple models (Application View)
  • Toolbars

Docking rules

UI Element Rules
Big windows
  • Can be undocked and moved out of the application
Small windows - Model Specific
  • Can be undocked and moved out of the application
  • Can be docked to right side and left side of a Big Window (Model explorer -> right side of Designer)
  • Can be docked to any side of another Model Specific Window (Object Viewer -> above Model Explorer)
Small windows - Non-Model Specific
  • Can be undocked and moved out of the application
  • Can be docked to any side of a Big Window (Message explorer -> above Scripting Window]
  • Can be docked to any side of another Non-Model Speciifc Window (Application View -> below Verification Log)
Toolbars
  • Can be undocked and moved out of the application
  • Can be docked to any side of a Big Window (Alignment Toolbar -> right side of Designer)

Note: Model Specific Windows cannot be docked to Non-Model Specific Windows. The opposite also applies.

To dock windows using SHIFT key

When you are dragging a window, Toad Data Modeler by default shows you available docking positions. If you don't like this behavior, you can enable it only when you are dragging a window and holding down SHIFT key simultaneously.

  1. Go to Settings Menu | Options.
  2. In section General, check Use SHIFT to Dock Forms checkbox.

To dock a window

Drag a window to the desired position and drop.

To dock a form/pane with SHIFT

  1. Hold down SHIFT key.
  2. Drag a window to the desired position.
  3. Release the mouse button and then SHIFT to dock the window.

The changed layout will be automatically saved after you close the application (.txe file).  

To undock a form/pane

Press SHIFT and double-click the top of the form (pane)

Hot Keys

User Interface > Interface Layout > Hot Keys
Shortcut Description

CTRL+N

Opens the New Model dialog.

CTRL+O

Opens already existing model.

CTRL+S

Saves a model.

CTRL+W

Creates a new Workspace (WS).

CTRL+F9

Opens the Model Verification dialog.

CTRL+E

Creates a new entity.

CTRL+R

Creates an identifying relationship.

CTRL+C  

Copies selected object(s).

CTRL+X  

Cuts selected objects(s).

CTRL+V  

Pastes copied or cut object(s).

CTRL+Z   

Undo step.

SHIFT+CTRL+Z  

Redo step.

CTRL+A  

Selects all.

CTRL+F   

Opens the Find dialog.

CTRL+ALT+F

Opens the Find in Scripts dialog.

CTRL+M Minimizes all undocked forms.

Del

Removes selected object(s) from Workspace.

SHIFT+Del

Deletes selected object(s) from model.

ALT+O

The Delete Confirmation dialog - OK button.

ALT+C

The Delete Confirmation dialog - Cancel button.

CTRL+M

Minimizes Forms.

CTRL+ALT+S

Synchronizes metamodel.

CTRL+I

Creates Inheritance (Logical Model).

F1

Opens the Help file.

F2

Renames model/object.

F9 Opens the DDL Script Generation dialog.
F11 Displays Toad Data Modeler in full screen mode.

CTRL+Up

Moves selected object(s) up. (Order of Generated Objects)

CTRL+Down

Moves selected object(s) down. (Order of Generated Objects)

Keyboard arrows

Moves shapes in Workspace (select a shape first).

SHIFT+keyboard arrows

Changes size of entity box.

CTRL+scroll mouse

Zooms in/out.

CTRL+, CTRL+Page Up

Zooms in.

CTRL-, CTRL+Page Down

Zooms out.

SHIFT+scroll mouse

Moves to the right/left on the Workspace.

Scroll mouse

Moves up/down on the Workspace.

Holding down the middle mouse button

Moves in entire page/Workspace.

Page Down, CTRL + down Moves to next page.
Page Up, CTRL + up Moves to previous page.
CTRL + left Moves to the left page.
CTRL + right Moves to the right page.
SHIFT + drag&drop the heading of a form/pane Docks the selected form/pane on a particular place in the Application Window.
SHIFT + double-click the heading of a form/pane Undocks the selected form/pane.

SHIFT

Multiple selection of objects (on the WS, dialogs, forms, Model Explorer etc.)

Drag&Drop techniques+CTRL+SHIFT

Creates a shortcut of object on the WS.  

Drag&Drop techniques from Model Explorer

Creates a shortcut of object on the WS.

Drag&drop techniques+CTRL

Copies objects on the WS/Object dialog (e.g. Entities dialog)/Model Explorer.

CTRL+Drag&Drop techniques

Copies attributes between entities in WS.

CTRL+click an attribute

Selects an attribute to move it to another entity box on the WS. (Click the attribute and release CTRL key to move the selected attribute.)

CTRL+click attributes

Multiple selection of attributes in entity box on the WS.

CTRL+double-click an object name

Renames the object name on the WS (including attributes).

CTRL+click a relationship line

Adds a handle point.

CTRL+click a handle point

Deletes the selected handle point.

ALT+click a relationship line

Selects a relationship line segment.

Inplace Editor

User Interface > Interface Layout > Inplace Editor

Toad Data Modeler allows you to edit items directly in appropriate place (Workspace, frame). E.g. you can change names of entities, attributes, indexes, relationships, views, categories, stamp items etc. directly on the WS.

See the following examples.

To change an entity name on the Workspace

  1. Click an entity on the Workspace.
  2. Press F2.

To change an attribute name on the Workspace

  1. Click an entity on the Workspace.
  2. Press CTRL and click the attribute you want to rename.
  3. Press F2 or hold the mouse left button for a while without moving (as in Windows).

To edit attribute properties directly in an entity frame:

  1. Open the Entity Properties form.
  2. Select the attribute property that you want to edit and press F2 (or click the item that you want to change, wait a second and click it again). Note that not every property is editable from this form.
  3. Change the value and click somewhere else in the grid.
  4. Confirm by clicking on Apply.

Layout Description

User Interface > Interface Layout > Layout Description

Simple and Minimalist Layout

Layout of Toad Data Modeler can be both simple and complex. Various panes can be docked on the left side, the right side or at the bottom of the application and some of the areas can be collapsed using tiny buttons in the middle of window splitters. The default layout for basic operations and tasks can be similar to this:

 

 

Expanded Area

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating