EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

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.