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 > Reference Data > Settings > Project Options > Source Code Engineering : DDL Name Templates

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.