MySQL Workbench! add prefix to all tables

Is it possible to set table prefix in MySQL workbench? For example: I have created a complete schema (table_1, table_2, table_3, ... table_N) and I want to ask Workbench to add a prefix to every table inside this schema when doing Forward Engineering. Want to see something like this in your SQL script

CREATE TABLE IF NOT EXISTS `mydb`.`myprefix_table_1`...

      

+3


source to share


1 answer


With your model or EER open, in the menu select "Tools" → "Catalog" - "Give a prefix for all tables in the catalog".



+6


source







All Articles