Exporting only table structure using mysqlworkbench

mysql mysql-workbench
user3275044 picture user3275044 · Mar 11, 2014 · Viewed 40.1k times · Source

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

Answer

Christian Mark picture Christian Mark · Mar 11, 2014

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)

Related questions

MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More
MySQL: How to allow remote connection to mysql

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source. How can I do that?

Read More
Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no privileges at all. I am having troubles across platforms that my server is …

Read More