Book a Demo

Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

Prev Next

DDL Name Templates

At various times during the process of data modeling, Enterprise Architect is required to automatically generate Table constraints. The naming standard for these generated constraints is defined in and applied by the DDL Name Templates, which you are free to change at any time. These Name templates are defined at repository level, so whenever they are changed all users of the repository will use the new templates.

Access

Ribbon

Configure > Model > Options > Source Code Engineering : DDL Name Templates Browse.

DDL Name Templates

Option

Action

See also

Primary Key

Define the name template used when Primary Key constraints are created.

Primary Keys

Unique Constraint

Define the name template used when Unique Constraints are created.

Unique Constraints

Foreign Key

Define the name template used when Foreign Key constraints are created.

Foreign Keys

Foreign Key Index

Define the name template used when Foreign Key indexes are created.

Save

Click on this button to save the name template(s) you have defined.

Template Macros

These recognized macros will be replaced by name text during the creation of a constraint name.

Macro

Applies to

See also

%tablename%

Primary Key

Unique Constraint

Description: The string that is replaced by the Table's name.

%columnname%

The string that is replaced by the constraint's column name(s).

%primarytablename%

Foreign Key

Description: The string that is replaced by the primary (parent) Table's name.

%foreigntablename%

The string that is replaced by the foreign (child) Table's name.

%foreignkeyname%

Foreign Key Index

Description: The string that is replaced by the Foreign Key name.