Scripts - Toad Data Modeler - Toad World

Toad Data Modeler Scripts

Override Identity

11 Feb 2013 at 3:15pm
The script will go through all FK attributes and will automatically select the checkbox Override Identity. After you execute the script, take a look at the Log window where all entities and attributes where the checkbox was selected will be written out. You...
1061 0 /

Add Prefix to Objects

11 Feb 2013 at 3:12pm
Prefix defined on the third line of the script will be added to every entity, index and trigger. The prefix will be added only once, which means that if you add another entity to your model later and run the script then, the prefix will be added only to this...
1068 0 /

Add Domain Object

11 Feb 2013 at 3:09pm
The script will add a new domain to your model. How to Execute Script: Unzip the attachment. Open it e.g. in Notepad. Copy and paste the script in the Scripting Window in TDM3. (Tools | Scripting Window). Run the script. (See the Execute button in...
955 0 /

Add Entity Object

11 Feb 2013 at 3:05pm
The script will add a new entity to your model. How to Execute Script: Unzip the attachment. Open it e.g. in Notepad. Copy and paste the script in the Scripting Window in TDM3. (Tools | Scripting Window). Run the script. (See the Execute button in...
1067 0 /

Rename NN (Not Null) Constraint Names

11 Feb 2013 at 2:58pm
The script will go through all NotNull attributes and will set their notnull constraint name in format NN_nameoftable_number. For names exceeding 30 characters, it will truncate the NN_nameoftable part. How to Execute Script: Unzip the attachment. Open...
1291 0 /

Convert Entity, Attribute Names to Lower Case

11 Feb 2013 at 2:57pm
The script will convert all attribute and entity names to lower case. If you need to modify the script, please feel free to do it. How to Execute Script: Unzip the attachment. Open it e.g. in Notepad. Copy and paste the script in the Scripting Window...
1246 0 /

Remove Physical Properties

11 Feb 2013 at 2:56pm
The script will remove content of the Physical Properties tab in Oracle models. If you need to modify the script, please feel free to do it. How to Execute Script: Unzip the attachment. Open it e.g. in Notepad. Copy and paste the script in the Scripting...
724 0 /

Rename Primary Key Names

11 Feb 2013 at 2:55pm
The script will rename names of primary keys. How to Execute Script: Unzip the attachment. Open it e.g. in Notepad. Copy and paste the script in the Scripting Window in TDM3. (Tools | Scripting Window). Run the script. (See the Execute button in...
1254 0 /

Order Entities Alphabetically

11 Feb 2013 at 2:54pm
The script will order entites alphabetically before you generate the SQL/DDL script. How to Execute Script: Unzip the attachment. Open it e.g. in Notepad. Copy and paste the script in the Scripting Window in TDM3. (Tools | Scripting Window). Run...
749 0 /

Create Indexes for Autoincrement Columns in MySQL

11 Feb 2013 at 2:52pm
The script creates indexes for all autoincrement columns in MySQL model. Execute the script in Scripting window (Tools menu, Expert mode on). Take notice of this part in the script: var Model = app.Models.GetObject(0); //The parameter in GetObject determines...
1161 0 /

Convert Caption to Physical Name

11 Feb 2013 at 2:50pm
The script converts caption of entities and attributes to physical name. Example: Caption: Order Record Physical Name: T_ORDER_RECORD Result - physical name: Order_Record How to Execute Script: Unzip the attachment. Open it e.g. in Notepad. Copy...
759 0 /

Notes to Comments Conversion

11 Feb 2013 at 2:49pm
The script moves Notes of entities and attributes to Comments. All supported databases How to Execute Script: Unzip the attachment. Open it e.g. in Notepad. Copy and paste the script in the Scripting Window in TDM3. (Tools | Scripting Window). ...
819 0 /

Create Workspaces by Schemas

11 Feb 2013 at 2:48pm
The script creates as many workspaces as many Schemas are in the model. If entity/view has a selected schema, the particular entity/view will be copied to particular workspace - placement and size of object will remain preserved. For entities, also relationships...
867 0 /

Create Workspaces by Users

11 Feb 2013 at 2:46pm
The script creates as many workspaces as many Users are in the model. If entity/view/materialized view has a selected user, the particular entity/view/materialized view will be copied to particular workspace - placement and size of object will remain preserved...
807 0 /

Change Data Type

11 Feb 2013 at 2:40pm
The script goes through all attributes and changes every Char data type (without specification if the length is in BYTE or CHAR) to Varchar2. Example: Char(20 BYTE) will be changed to Varchar2(20). You can use the script to change a data type. How to Execute...
2102 0 /