Chat now with support
Chat with Support

Toad Data Modeler 7.0 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Create New Project Reports Reverse Engineering Scripting and Customization About Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Amazon Redshift 1.0 IBM DB2 LUW 9.5 IBM DB2 LUW 9.7 IBM DB2 LUW 10.1 IBM DB2 LUW 10.5 IBM DB2 LUW 11.1 IBM DB2 z/OS 10 IBM DB2 z/OS 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 EDB Postgres Advanced Server 10 Microsoft Access 2007/2010 Microsoft Azure SQL Database V12 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 Microsoft SQL Server 2017 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 MySQL 8.0 Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 Oracle 18c Specifics - Oracle 12c Release 2 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 PostgreSQL 10 SQLite 3.7 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
Copyright Legal Notices

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

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

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.

Message Explorer

In Message Explorer you can see hints, errors, warnings and other messages that appear during your work with Toad Data Modeler.

Message Explorer is by default docked at the bottom of the application window. However, you can hide or close it at any time.

To open Message Explorer again

Select Window | Message Explorer Log.

You can sort messages by IDs, date, time and message type, simply click on the appropriate column.

Message Explorer versus Log Area

Log area in appropriate forms/dialogs/wizard displays information only on the operation taking place in the particular form/dialog/wizard. (Show/Hide Log options are available.)

Message Explorer displays information about all ongoing operations.

 

Message Explorer Right-Click Options

Right-click the selected message to see the following options:

Option Description

Details

Displays details on the selected message.

TIP: Double-click the selected message opens the details too. Use Next and Previous buttons for quick navigation among messages.

View Options

Opens the Message Explorer Properties dialog where you can define:

  • What information you want to see in the Message Explorer (Date, Time, Format, Type),
  • Type of messages (Errors, Warnings, Information, Hints etc.),
  • Path to save the Log.txt file on tab Message Saving.

Save Messages to File - If this checkbox is checked, the messages displayed in Message Explorer will be saved to the Log.txt file continuously.

Overwrite File - If this checkbox is checked, new messages overwrite old messages. If this checkbox is unchecked, new messages are listed after the older messages in the Log.txt file.

By default, the following path is set up in the Settings menu | Options | Paths | Message Explorer Log Path:

C:\Documents and Settings\%UserName%\My Documents\Toad Data Modeler\Log

Clear Messages

Clears the Message Explorer.

Note: Undo/Redo cannot be applied here.

Save Messages

Opens the Save As dialog via which you can save all messages to LocalLog.txt file.

Save Selected Messages

Opens the Save As dialog via which you can save the selected messages to LocalLog.txt file.

Related Documents