Page History

Provides and interface to add multiple partitions to clustered indexes.

A list of tables is provided. Selecting a table will load the clustered indexes to be partitioned. The storage parameters are uniform across partitions.

Selects the related parents and/or child of the selected tables.

To use the macro, lasso a group of entities on the diagram or select them in the diagram tree, and then right click on the macro to execute.

Parents and children

are selected depending if the option is checked.

Use this macro

to assist in submodel creation.

Import Data Dictionary objects from a flat file.

The imported file has to follow a specific format guidelines listed in the comments with examples.

Applies naming conventions to all types of indexes.

It provides an option to use the selected tables or all tables. The prefix and suffix variables can be used to add company specific conventions to the beginning and/or end of the target name.

The target name can be either the existing name, table name, tablespace name or database name. The tablespace and database can only be used for applicable platforms such as Oracle or DB2.

Truncate parameters can also be specified to remove the first N characters or the last N characters of the target name.

Use another parameter to limit the total number of characters in the target name. These are applied before the prefix and suffix are added.

Prompts the user with a dialog to specify the naming convention for Foreign Constraints.

It

then

names all of the constraints using the parent and child table names

and makes sure that the name is unique by adding an index for the last characters of duplicate names.

Names all primary key constraints with the given naming conventions.

The table name with either a prefix or suffix.