How to get a table creation script in MySQL Workbench - MySQL DBA Tutorial

How to get a table creation script in MySQL Workbench

How to get a table creation script in MySQL Workbench
Often as MySQL DBAs or developers we need to script the create definition of a table so we can create new table with same table definition. Also we use these scripts in lower environments such as DEV, QA and UAT To create same tables what we have on Prod. 
MySQL workbench let you generate create table definition by many methods such as Table inspector or by right clicking on table and going to "To SQL Query Window" you can choose create table option.


MySQL Workbench Tutorial - Get a table creation script in MySQL Workbench

1 comment: