13.5.4.7. SHOW CREATE TABLE Syntax
SHOW CREATE TABLE tbl_name
Shows the CREATE TABLE statement that
creates the given table. This statement also works with views.
mysql> SHOW CREATE TABLE t\G
*************************** 1. row ***************************
Table: t
Create Table: CREATE TABLE t (
id INT(11) default NULL auto_increment,
s char(60) default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM
SHOW CREATE TABLE quotes table and column
names according to the value of the
SQL_QUOTE_SHOW_CREATE option. See
Section 13.5.3, “SET Syntax”.
