(mysql.info.gz) SHOW CREATE TABLE

Info Catalog

(mysql.info.gz) SHOW CREATE DATABASE

(mysql.info.gz) SHOW

(mysql.info.gz) SHOW CREATE VIEW

 
 13.5.4.5 `SHOW CREATE TABLE' Syntax
 ...................................
 
      SHOW CREATE TABLE TBL_NAME
 
 Shows a `CREATE TABLE' statement that will create the given table.  It
 was added in MySQL 3.23.20.
 
      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' quotes table and column names according to the
 value of the `SQL_QUOTE_SHOW_CREATE' option.   `SET
 SQL_QUOTE_SHOW_CREATE' SET OPTION.
 

Info Catalog

(mysql.info.gz) SHOW CREATE DATABASE

(mysql.info.gz) SHOW

(mysql.info.gz) SHOW CREATE VIEW