(mysql.info) show-create-table

Info Catalog

(mysql.info) show-create-procedure

(mysql.info) show

(mysql.info) show-create-view

 
 13.5.4.6 `SHOW CREATE TABLE' Syntax
 ...................................
 
      SHOW CREATE TABLE TBL_NAME
 
 Shows the `CREATE TABLE' statement that creates the given table. As of
 MySQL 5.0.1, 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  set-option.
 

Info Catalog

(mysql.info) show-create-procedure

(mysql.info) show

(mysql.info) show-create-view