Is it possible to set the table prefix in the MySQL workbench?
For example: I created a complete pattern (table_1, table_2, table_3,… table_N), and I want Workbench to add a prefix to each table in the pattern when I execute Forward Engineering.
I want to use it in the SQL script See something similar
For example: I created a complete pattern (table_1, table_2, table_3,… table_N), and I want Workbench to add a prefix to each table in the pattern when I execute Forward Engineering.
I want to use it in the SQL script See something similar
CREATE TABLE IF NOT EXISTS `mydb`.`myprefix_table_1`...
Open the model or EER, select Tools-> Table of Contents-> “Provide a prefix for all tables from the table of contents”.
Is it possible to set table prefix in MySQL workbench?
For example: I created a complete pattern (table_1, table_2, table_3,… table_N), and I want Workbench to add a prefix to each table in the pattern when I execute Forward Engineering.
I want to use it in the SQL script See something similar
CREATE TABLE IF NOT EXISTS `mydb`.`myprefix_table_1`...
Open the model or EER, select Tools-> Catalog-> “Provide a prefix for all tables from the catalog”.