Online Documentation for SQL Manager for SQL server

Foreign Key Names


Use the Foreign Key Names tab to set the template for the name of the newly created foreign key.

 

Object Templates - Foreign key names

 

 

The following tags are available:

{table_name} - the name of the table in which the foreign key is created;

{num} - the ordinal number of a foreign key with the same name;

{num_for_dup} - the number of a foreign key which is applied if the foreign key with the same name (without an ordinal number) already exists.

{ref_table_name} - the name of the table which is referenced using the foreign key (foreign table name);

{fields} - names of table fields which are included in the foreign key;

{ref_fields} - names of the foreign table fields.

 

Click the tag to insert it at the cursor position.