Syntax:
SHOW CREATE TABLE tbl_name

Shows the CREATE TABLE statement that creates the named table. To use
this statement, you must have some privilege for the table. This
statement also works with views.
SHOW CREATE TABLE quotes table and column names according to the value
of the sql_quote_show_create option. See
http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html.

For information about how CREATE TABLE statements are stored by MySQL,
see
http://dev.mysql.com/doc/refman/5.7/en/create-table-statement-retention
.html.

URL: http://dev.mysql.com/doc/refman/5.7/en/show-create-table.html

