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;

{table_schema} - the name of the schema that contains the table;

{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);

{ref_table_schema} - the name of the schema containing the table referenced by the foreign key;

{columns} - names of columns on which the foreign key is created;

{ref_columns} - the name of the column referenced by the foreign key.

 

Click the tag to insert it at the cursor position.