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.
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.
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:
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.
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}
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.