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

Functions

Functions

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

To add a function

Right-click the Functions item in Model Explorer | Add Function.

To edit a function

Double-click the selected function in Model Explorer | Functions (or right-click Edit).

Example: The Function Properties dialog (Oracle 10g)

General Tab

Description

Caption

Logical function name

Name

Physical function name

Schema

Schema selection box

Invoker Rights (CURRENT_USER)

Database dependent option. See particular database reference for more information.

Function Arguments

Write function arguments here.

Datatype of the Return Value

Define data type of the return value.

Deterministic

Database dependent option. See particular database reference for more information.

Definition is Wrapped

Database dependent option. See particular database reference for more information.

Generate

Select it to generate the function in final SQL (DDL) script.

Generate SQL only

Select it to generate only the content of the SQL tab. All other items will be ignored.

SQL Tab

SQL code. (See the example in the following screenshot.)

About Templates

To Do Tab

On this tab, you can write some tasks on the selected function.   

Permissions Tab

On this tab, you can assign a User or User Group permissions for selected function.

Before Script Tab

Whatever you write here, it will be generated after the function definition.

After Script Tab

Whatever you write here, it will be generated before the function definition.

Notes Tab

Tab for notes on particular function.

Example: The Function Properties dialog | SQL tab (Oracle 10g)

Defaults

Defaults

Models and Model Objects > Physical Data Model > Entity Relationship Diagram Objects > Defaults

To add a default

Select Model | Model Items |Defaults and click Add in the Defaults dialog.

To edit a default

Select Model | Model Items | Defaults and double-click the selected default or click Edit.

Note: You can also edit/rename/delete defaults in Model Explorer | Defaults folder | Right-click the selected default.

Example: The Default Properties dialog (Oracle 10g)

To select a default for attributes

  1. Open the Attribute Properties dialog of the selected attribute | General tab.
  2. From the Default Rule box, select a default or write your own default to the Default box.

Default box versus Default Rule combo-box

Default box - Set a default for particular attribute.

or

Default Rule - Select a default rule from the combo-box or click the button on the right to access the Defaults dialog (also accessible via Model menu | Model Items | Defaults). There, you can define a new default rule. Then, if you want to change the default rule, you can simply change it via the Defaults dialog. The change will automatically apply in all attributes with this default rule.

Note: You can define defaults for domains too.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating