Toad Data Modeler 7.2 - User Guide

Entity

DML Logging box with default / full / minimal values.

Attribute

New Encrypted Column area with Encryption Key and Decrypt Default.

Computed Column - It is not a data type. Select this item from Data Type box if you want to set column as computed.

Default rule Is Default Object - Select this checkbox if you want to bind default rule (known as default object in Sybase ASE)  to attribute.

Rule Object - Select a rule object that will be bound to attribute.

Encryption Keys

Trigger

New inactive (informational) box Trigger Fire .

Trigger is now available also for Views.

Web Services

See other objects in Model Explorer:

• Segments

• Encryption Key

• Web Service

Available Data Providers are:

• Connection via ODBC
• Connection via ADO
• Native Connection

Connection via ODBC

Connection via ADO

Native Connection:

Entity

Compression box: none, page, row.

Examples:

Table Compression

create table t01 (a varchar(50) not null, b varchar(50) not null) with compression = none

Table Lob Compression + level

create table t02 (a varchar integer) with lob_compression = 0

Column Compressed

create table tab03 (a text not compressed)

Attribute

From the Data Type box, select Computed Column and define other properties in the Computed Column area.

Example:

create table tab04 (acompa as 'orderno' materialized not compressed) with lob_compression = 5

 

See other objects in Model Explorer:

• Encryption Keys
• Segments
• Web Services