Reputation: 18986
When investigation
I found following answer
How do I generate a SQL script from my diagram in MySQL Workbench?
BUT its generate ALL database tables code into ONLY ONE single SQL script
Any Help to generate the database tables code into Multi Separated SQL script(s)
Upvotes: 0
Views: 187
Reputation: 18986
Open (Data Export) by selecting following menu item
Server -> Data Export
Then
Dump Structure Only
Export to Dump project folder
start export
Upvotes: 0
Reputation: 53317
There is no direct way to exclude or include a specific database in the output script, however you can use a workaround. On the SQL Object Export Filter page you can determine which objects to export. Since it supports multiselection and is sorted alphabetically (so all objects from one schema stay together) you can quickly collect object lists for each schema.
Upvotes: 1