Syntax:
SHOW CREATE TABLE tbl_name

Shows the CREATE TABLE statement that creates the given 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.1/en/server-session-variables.html.

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

