|
Check/Uncheck the 'Generate Index to Foreign Keys' checkbox
[2863]
Last Modified:
May 14, 2009 5:17 AM
The script goes through all identifying relationships in your model where it clears the Generate Index to Foreign Keys checkbox, and through all non-identifying relationships where it selects the Generate Index to Foreign Keys checkbox.
Oracle db
|
|
|
|
Uncheck 'Generate Index to Foreign Keys' for Identifying Relationships
[2862]
Last Modified:
May 14, 2009 5:12 AM
The script goes through all identifying relationships in your model and clears the Generate Index to Foreign Keys checkbox.
Oracle db
|
|
|
|
Change Data Type
[2663]
Last Modified:
Mar 17, 2009 5:27 AM
The script goes through all attributes and changes every Char data type (without specification if the length is in BYTE or CHAR) to Varchar2.
Oracle db
|
|
|
|
Create Workspaces by Users
[2662]
Last Modified:
Mar 17, 2009 5:19 AM
The script creates as many workspaces as many Users are in the model.
Oracle db
|
|
|
|
Create Workspaces by Schemas
[2651]
Last Modified:
Mar 17, 2009 5:18 AM
The script creates as many workspaces as many Schemas are in the model.
All supported databases with Schemas
|
|
|
|
Notes to Comments Conversion
[2645]
Last Modified:
Mar 13, 2009 1:23 AM
The script moves Notes of entities and attributes to Comments.
All supported databases
How to Execute Script:
1. Unzip the attachment.
2. Open it e.g. in Notepad.
3. Copy and paste the script in the Scripting Window
|
|
|
|
Convert Caption to Physical Name
[2342]
Last Modified:
Oct 21, 2008 7:58 AM
The script converts caption of entities and attributes to physical name.
|
|
|
|
Create Indexes for Autoincrement Columns in MySQL
[2245]
Last Modified:
Sep 22, 2008 11:48 PM
The script creates indexes for all autoincrement columns in MySQL model.
MySQL db
|
|
|
|
Order Entities Alphabetically
[1869]
Last Modified:
Apr 28, 2008 2:29 AM
Order entites alphabetically before you generate the SQL/DDL script.
All supported databases
|
|
|
|
Rename Primary Key Names
[1868]
Last Modified:
Apr 28, 2008 2:26 AM
Rename names of primary keys.
All supported databases
|
|
|
|
Remove Physical Properties
[1698]
Last Modified:
Mar 10, 2008 3:10 AM
The script will remove content of the Physical Properties tab in Oracle models.
|
|
|
|
Convert Entity, Attribute Names to Lower Case
[1363]
Last Modified:
Dec 14, 2007 6:02 AM
The script will convert all attribute and entity names to lower case.
All supported databases
|
|
|
|
Rename NN Constraint Names
[1361]
Last Modified:
Dec 10, 2007 11:58 PM
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.
Oracle db
|
|
|
|
Add Entity Object
[1352]
Last Modified:
Nov 30, 2007 6:12 AM
Add an entity to your model via script.
(on an example of Oracle model)
|
|
|
|
Add Domain Object
[1351]
Last Modified:
Nov 30, 2007 6:00 AM
Add a domain to your model.
(on an example of Oracle model)
|
|
