Define Foreign Key Name Template

To define the name template for a Foreign Key, follow the steps below:

  1. Select the Tools | Options | Source Code Engineering | Code Editors menu option. The Code Editors page of the Options dialog displays.
  2. Click on the DDL Name Template button. The DDL Name Template dialog displays, showing the default name templates.
  3. Edit or replace the name template in the Foreign Key Name Template field.


If you want to display the Foreign Key description as FK_foreigntablename_FKcolumnname_primarytablename_PKcolumnname then change the Foreign Key Name Template field to FK_%foreigntablename%_%fkcolumnname%_%primarytablename%_%pkcolumnname%.

  1. Click on the Save button.