Exporting only table structure using mysqlworkbench

For those of you that like the visual answer :

Start export - done :)

To get an individual table's creation script:

• just right click on the table name and click Copy to Clipboard > Create Statement.

To enable the File:

• Forward Engineering SQL_CREATE Script.. option and to get the creation script for your entire database:

  1. Database > Reverse Engineer (Ctrl+R)
  2. Go through the steps to create the EER Diagram
  3. When viewing the EER Diagram click File > Forward Engineering SQL_CREATE Script... (Ctrl+Shift+G)

It's possible to do this at once too. Select "Data Export" in the navigator and then select the schema and the required tables. Then check the checkbox saying "Skip table data(no data)" and then click on "Start Export" button.