GNU Info

(mysql.info)SHOW CREATE TABLE

---

Prev: SHOW GRANTS Up: SHOW

---

Enter node , (file) or (file)node

`SHOW CREATE TABLE'
...................

Shows a `CREATE TABLE' statement that will create the given table:

     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)
     ) TYPE=MyISAM

`SHOW CREATE TABLE' will quote table and column names according to
`SQL_QUOTE_SHOW_CREATE' option.  Note: `SET OPTION
SQL_QUOTE_SHOW_CREATE'.