Toad Data Modeler 7.3 - User Guide

Toad Data Modeler supports MySQL 8.0 in Reverse Engineering from a database, from a SQL file, Change Script Generation and SQL/DDL Code Generation

See Reverse Engineering - MySQL 5.0 for more information.

See Script Generation - MySQL 5.0 for more information.

Entity

External tables are supported. On tab Physical Properties, select the External Table (Organization External) checkbox. The External Table Properties tab will occur on the form.

Attribute

Data Types:

For Char and Varchar2 data types, you can define Column Length in.

For User data type, you can define REF options.

Used Sequence (trigger) - From this box, you can select a sequence that you want to use for the attribute. (A new trigger will be created in SQL script.)

Encryption Specification - Here, you can write e.g. USING 'AES192' NO SALT.

Index

Example of Expression index:

Example: Index properties (for domain index):

Trigger

User Data Type

When you select Varray Type or Nested Table Type, a new tab displays (Varray Type tab or Nested Table Type tab). There, you can see new boxes where you write appropriate values. Click Create Definition and the definition will be written in the memobox.

The content of the boxes is not saved and is not used for reverse engineering, script or report generation.

Hints in memoboxes for User Data Types are shown.

Other Notes

• Dictionary types are not supported for Oracle models.
• User Data Types on user data types in Oracle model.

Materialized View

Procedure

Function

Directory

Java

Support for Oracle Java Source, including reverse engineering: All the three types of Java schema objects (SOURCE, CLASS, RESOURCE) should be written to this object. - During reverse engineering only SOURCE types are loaded, and from them only sequences of characters for Java source. Other Java schema objects (CLASS, RESOURCE) are loaded only as a name. Checkbox Generate is unselected for all the Java schema objects (SOURCE, CLASS, RESOURCE).

Sequence

Synonym

Tablespaces