Syntax:
SHOW CREATE TABLE tbl_name

Shows the CREATE TABLE statement that creates the given table. The
statement requires the SELECT 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.1/en/server-system-variables.html.

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

