SHOW CREATE TABLE displays the CREATE TABLE statement to create a given table.

Shows the CREATE TABLE statement that creates the given table. The statement requires the SELECT privilege for the table. As of MySQL 5.0.1, this statement also works with views.

 

mysql> SHOW CREATE TABLE tablename