Exporting SQL structure commands from MySQL Workbench


You would like to export the structure of some specific MySQL tables using MySQL Workbench (ie to create same tables in another database).


Go to the table name, right click, select ‘Copy To Clipboard’, then ‘Create Statement’ and finally go to a new file or editor and paste the command from the clipboard.
Just have in mind that you may need to delete the AUTO_INCREMENT from the SQL.
Solution was described here