(mysql.info) show-create-database

(mysql.info) show-create-procedure

 
 13.5.4.4 `SHOW CREATE DATABASE' Syntax
 ......................................
 
      SHOW CREATE {DATABASE | SCHEMA} DB_NAME
 
 Shows the `CREATE DATABASE' statement that creates the given database.
 `SHOW CREATE SCHEMA' is a synonym for `SHOW CREATE DATABASE' as of
 MySQL 5.0.2.
 
      mysql> SHOW CREATE DATABASE test\G
      *************************** 1. row ***************************
             Database: test
      Create Database: CREATE DATABASE `test`
                       /*!40100 DEFAULT CHARACTER SET latin1 */
 
      mysql> SHOW CREATE SCHEMA test\G
      *************************** 1. row ***************************
             Database: test
      Create Database: CREATE DATABASE `test`
                       /*!40100 DEFAULT CHARACTER SET latin1 */
 
 `SHOW CREATE DATABASE' quotes table and column names according to the
 value of the `SQL_QUOTE_SHOW_CREATE' option. See  set-option.

Info Catalog

(mysql.info) show-columns

(mysql.info) show

(mysql.info) show-create-procedure

automatically generated byinfo2html