How to view a table's CREATE TABLE statement in MySQL

Get the CREATE TABLE statement of an existing table called my_table:

SHOW CREATE TABLE my_table;

Get started with DB Pilot

Download DB Pilot, the database GUI with a twist.
Speed up your SQL workflows today.