Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Forward engineer a Workbench model but with my own name for the scheme

How can I forward engineer a Workbench model with my given name of the database scheme?

Yes I can edit it in the editor window shown on the image, but what if I have 30 tables to export as SQL code?

Yes I can use find/replace tool before executing the exported SQL, but you can forget to use it and therefore export scheme with wrong name. I also have to drop "mydb" to keep MySQL clean.

Or is it at all possible?

As shown on the image I want to replace "mydb" with for example "animalsDB"

mysqlworkbench

like image 988
Vlad Avatar asked Oct 26 '25 14:10

Vlad


1 Answers

In order to avoid qualified object identifiers (that include the schema) set the option as shown in the image for the forward engineering operation.

enter image description here

like image 65
Mike Lischke Avatar answered Oct 29 '25 05:10

Mike Lischke



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!