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

Script Generating

Databases > Microsoft Access 2007/2010 > Script Generating

Toad Data Modeler doesn’t generate an SQL script for the Microsoft Access database, but does generate a fully functional source code in the VBA language. The source code can be executed directly in the Microsoft Access as Module. Appropriate libraries in Microsoft Access are necessary - "Microsoft ActiveX Data Objects 2.x Library" and "Microsoft ADO Ext. 2.x for DDL and Security" for ADO, or "Microsoft DAO 3.6 Object Library" for DAO.

To select a suitable library, click the Tools menu | References (in Microsoft Access main menu).

In the beginning of every script generated for Microsoft Access, you will see the following order:

Microsoft Azure SQL Database

Reverse Engineering

Databases > Microsoft Azure SQL Database > Reverse Engineering

Available Data Providers are:

  • Connection via ADO
  • Native Connection

Connection via ADO:

Native Connection:

Specifics

Databases > Microsoft Azure SQL Database > Specifics
 

Attribute

Computed Column Expression box – Available for the Computed Column data type.

Persisted Computed Column checkbox – Available for the Computed Column data type.

Collation for The Column box – Available for data types Char(x), NChar(x), NText, NVarChar(x), NVarChar(max), Text, VarChar(x), VarChar(max).

If a domain is selected in the Attribute Properties dialog, Domains box, and the domain has a data type with selected Collation, the Collation box is available. Also the Identity properties are available. Click to overwrite them.

 

Domain

Computed Column Expression box - Available for the Computed Column data type.

Persisted Computed Column checkbox - Available for the Computed Column data type.

Collation for The Column box – Available for data types Char(x), NChar(x), NText, NVarChar(x), NVarChar(max), Text, VarChar(x), VarChar(max).

See tab Identity for checkboxes Identity and boxes Identity Seed and Identity Increment.

Key

StatisticsNorecompute, Ignore_dup_key, IndexOptions, Clustered

See the Clustered checkbox on tab General and other options on tab Index Options.

 

Index

Predicate, StatisticsNorecompute, IndexOptions, IncludeCols, Ignore_dup_key

Include Columns List – If it is necessary, column names divided by comma are written there.

It is possible to set Ascending/Descending only for specific items of the index.

    

User Data Type

TType, TableTypeList, SQL, GenerateSQLOnly

Possibility to define User-Defined Table Type in User Data Type.

Typebox – Only TABLE is possible to select.

User-Defined Table Type Definition box – E.g. LocationName VARCHAR(50), CostRate INT

If the checkbox Generate SQL Only is selected, tab SQL will be displayed.

 

Trigger (Entity, View)

Trigger Fire box – For entities you can select AFTER or INSTEAD OF

Trigger Events box with checkboxes Delete, Insert, Update

Execute as box – If 'user_name' is selected, a box where you can define the user name will be displayed.

 

View

Tab Create Index - There, you can write the complete command (or more) CREATE INDEX with index definition for the particular view.

Tab View Comment – There you can write comments that should be generated in DDL script before command CREATE VIEW.
Example: -- comment on my view

 

Procedure

Type of Stored Procedure box – Only Stored Procedure is possible to select.

Execute as box - If 'user_name' is selected, a box where you can define the user name will be displayed.

Tab Procedure Comment - There you can write comments that should be generated in DDL script before command CREATE PROCEDURE. Example: -- comment on my procedure

 

Function

Type of Function combo box– It is possible to select Scalar Function and Table-valued Function.

Execute as box - If 'user_name' is selected, a box where you can define the user name will be displayed.

OnNULLCall Attribute combo box – It is available only for Scalar Function.

Return Data Type box – For Table-valued Function they are called Returns.

Tab Function Comment - There you can write comments that should be generated in DDL script before command CREATE FUNCTION.
Example: -- comment on my function

 

Synonym

Base Object is not in List checkbox - If the checkbox is selected, the Base Object box will be displayed. There you can write a name of object for which the synonym is defined. This option is used if the object is not available in the box Object.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating