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

Format Relationship Lines

Models and Model Objects > Physical Data Model > Entity Relationship Diagram Objects > Format Relationship Lines

In Toad Data Modeler, you can change format of a particular relationship or more relationships at one jump. (Use SHIFT key for multiple selection.)

To change format of all relationship lines on the Workspace

Right-click the WS and select Workspace Format.

To change format of the selected relationship(s)

Right-click the relationship and select Format.

To change format of the relationship name (caption)

Right-click the relationship | Format | Click Font Settings and define the settings in the Font dialog.

 

TIP: Use the Inplace editor to change the relationship name in your diagram directly. Inplace Editor

Relationship Right-Click Options

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

Option Description

Format

Opens the Object Format dialog for the selected relationship.

Add into Workspace

Opens the Workspaces dialog where you can select a WS to add the relationship to. (The entities that the relationship connects will be inserted as well.)

Add into New Workspace

Creates a new Workspace in the Application Window and adds the relationship to it (including the entities that the relationship connects).

Remove from Workspace

Removes the selected shortcut from particular Workspace.

Delete Object

Deletes the selected relationship from model.

Arrange

Arranges the relationship in another layer.

Arrange Objects in Layers

Add Object to Gallery You can add the relationship in a gallery.

Line Style

There are several predefined patterns of line style. The letter in symbolizes the shape of the resulting relationship line:

Unhide Line - Displays the part of relationship line hidden behind entity/view boxes.

Delete Part of Line

Removes selected part of line.

Move Caption Here

Moves the caption of the relationship to the position where you pressed the right-click.

Move Caption to Parent Moves the caption of the relationship to the parent table of the relationship.
Move Caption to Child Moves the caption of the relationship to the child table of the relationship.
Go to Parent Locates parent entity in ERD.
Go to Child Locates child entity in ERD.

Edit

Opens the Relationship Properties dialog.

Edit Entities/Views

Opens the parent/child Entity Properties form.

Add to Category Add the relationship to current or new category.
Macros Provides available macros for relationships.

Views

Views

Models and Model Objects > Physical Data Model > Advanced Database Design > Views

Toad Data Modeler allows you to display and model views in your ER diagrams visually.

You can manage Views via:

  • Model menu | Model Items |Views
  • Model Explorer | Views folder

View properties and options are database dependent.

To create a new View

  1. Click on the toolbar and then click the workspace.
  2. Click on the toolbar and draw view relationships between some existing table or view and your newly created view.
  3. Double click the view relationship line to edit it. In Alias field you can specify a new alias name for the linked table.


  4. Double-click the view to edit it.
  5. Define properties on General tab and other tabs.
  6. On tab Attributes you can select columns from the linked tables. Relationship aliases and names of entities are displayed.

  1. You can use a template on SQL tab of the view.

Note: As well as for entities and relationships, you can create shortcuts of views on the workspaces of your model. List of view shortcuts can be found in Model Explorer | in particular Workspace folder and in the Views folder | Shortcuts.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating