Search code examples
mysqlmysql-workbench

Exporting only table structure using mysqlworkbench

Can anybody tell whether it possible for exporting only the table structure using MySQL workbench

Solution

  • 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)