Online Documentation for SQL Manager for MySQL

Table subobjects


Using the Foreign keys tab you can set a template for foreign key naming. The Insert Tag drop-down list allows you to select one or more tags that may simplify template creation:

Table Name: {table_name}

Serial Number (for duplicates): {num_for_dup}

Referenced Table Name: {ref_table_name}

 

 

 

Use the Insert Tag button to add the selected tag value to the template, e.g. {table_name}, {num_for_dup}, etc.

 

 

This page allows you to define name templates for table subobjects.

 

 

ObjectTemplates - Subobjects

 

Use the Field and Index fields to define name templates for newly created objects.

Press the Insert Tag button and select an item from the drop-down list to add a tag to name template.

 

ObjectTemplates - Subobjects_Field_Index_naming template

 

 

Table Name: [OwnerName];

Serial Number (for duplicates): [name_for_dup].

 

 

Using the Foreign keys tab you can set a template for foreign key naming. The Insert Tag drop-down list allows you to select one or more tags that may simplify template creation:

 

ObjectTemplates - Subobjects_Foreign_key naming template

 

Table Name: {table_name}

Serial Number (for duplicates): {num_for_dup}

Referenced Table Name: {ref_table_name}

 

Using the Triggers tab you can set a template for trigger naming. Here you can also specify templates for tags added to default names of Before and After trigger types and for tag parts added to trigger events: Insert, Update, Delete.

 

ObjectTemplates - Subobjects_Trigger

 

The Insert Tag drop-down list allows you to select one or more tags that may simplify template creation:

 

ObjectTemplates - Subobjects_Trigger naming template

 

Table Name: {table_name}

Serial Number (for duplicates): {num_for_dup}

Trigger Type: {trig_type}

Trigger Events: {trig_events}

 

Example:

For newly created foreign key you define:

  • prefix "fk_"
  • ID for the first table "T1"
  • tag [table_name]
  • ID for the referenced table "T2"
  • tag - [ref_table_name]

 

Template in this case will be 'fk_T1[OwnerName]_T2[num_for_dup]'.

Foreign key name created with this template will be: "fk_T1Lotti_MateriePrime_T2Commesse_Lotti", where Lotti_MateriePrime and Commesse_Lotti are table names.