Define a Foreign Key Name Template

If you have specific modeling conventions that stipulate how Foreign Keys are documented, you can customize the way Foreign Key relationships are named by default.

By changing the Foreign Key Name Template, you adjust the name that the system assigns to the Association connector and Operation that define the Foreign Key relationship.

Access    Tools | Options | Source Code Engineering | Code Editors: DDL Name Template

Define the name template for a Foreign Key

Step

Action

See also

1

Click on the DDL Name Template ( ... ) button.

The DDL Name Templates dialog displays, showing the default name templates.

 

 

2

Edit or replace the name template in the Foreign Key field.

For example, if you want to display the Foreign Key description as:

FK_foreigntablename_FKcolumnname_primarytablename_PKcolumnname
 

then change the Foreign Key Name field to:

FK_%foreigntablename%_%fkcolumnname%_%primarytablename%_%pkcolumnname%

 

 

3

Click on the Save button.