Define a Foreign Key Index Template

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

By changing the Foreign Key Index Template, you adjust the name the system assigns to the Index Operation that you can optionally define within the Foreign Key relationship.

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

Define the Index template for a Foreign Key

Step

Action

See also

1

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

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

 

 

2

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

For example, if you want to create Foreign Key Indexes with the same name as the Foreign Keys, but include a prefix of IX, then change the Foreign Key Index field to:
 

IX%foreignkeyname%

 

3

Click on the Save button.

 

 

Learn more