CODEWITHSUNDEEP
mysqlmysql-workbench
LINKeRxUA
LINKeRxUA

Reputation: 559

MySQL Workbench! add prefix to all tabels

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

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

Upvotes: 3

Views: 2872

Answers (1)

George
George

Reputation: 311

Having your model or EER open, select Tools --> Catalog --> "Give a Prefix to All Tables in Catalog" from the menu.

Upvotes: 7

Related Questions