Using WinMySQL Professional

Analyze database - Tables «create» SQL script

Only accessible when connected, the «Server administration>Analyze database>Tables 'create' SQL script» submenu accesses to a basic «reverse engineering» feature. Indeed, it allows to generate the SQL script which creates all the tables held into the current database. This feature is useful to clone a database structure or to complete the analysis folder for the current database.

To do it, just click on the «Server administration>Analyze database>Tables 'create' SQL script» submenu and then, choose a name for the resulting *.sql file.

You may, for instance, reuse this resulting script with the pseudo-terminal (invoking the submenu File>New>SQL query ) or reuse parts of it with the «mysql» client on the server (in this case, you must separate the queries and add a trailing semicolon character after the last query).