|Previous Top Next|
Name templates come in very handy when you're creating new objects like triggers, constraints, auto-indices, SUID procedures and more.
By using these templates, you can create standard naming conventions, like Primary Key constraints that always start with PK_ - or referential constraints (foreign key constraints) like FK_TABLE1_TABLE2.
The Name Templates editor in the Preferences Screen
If you create a Foreign Key Constraint in the Constraint Editor, the "%REFTAB%" part will stay in the name of the constraint until you selected the "referred" table from the available tables drop down box.
The "Auto ..." name templates are used in the Table Editor Field Specials dialog.
Replaceable parts in the Template Value entries:
If %SHORTTAB% is used in the Foreign Key Constraint template, the %REFTAB% template value is also using the first n characters.