(mysql.info.gz) SHOW CREATE DATABASE

Info Catalog

(mysql.info.gz) SHOW COLUMNS

(mysql.info.gz) SHOW

(mysql.info.gz) SHOW CREATE TABLE

 
 13.5.4.4 `SHOW CREATE DATABASE' Syntax
 ......................................
 
      SHOW CREATE {DATABASE | SCHEMA} DB_NAME
 
 Shows a `CREATE DATABASE' statement that will create the given
 database.  It was added in MySQL 4.1.  `SHOW CREATE SCHEMA' can be used
 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 */
 

Info Catalog

(mysql.info.gz) SHOW COLUMNS

(mysql.info.gz) SHOW

(mysql.info.gz) SHOW CREATE TABLE