user3275044 user3275044 - 9 days ago 5
MySQL Question

Exporting only table structure using mysqlworkbench

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

Answer

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