(mysql.info.gz) SHOW CREATE VIEW

Info Catalog

(mysql.info.gz) SHOW CREATE TABLE

(mysql.info.gz) SHOW

(mysql.info.gz) SHOW DATABASES

 
 13.5.4.6 `SHOW CREATE VIEW' Syntax
 ..................................
 
      SHOW CREATE VIEW VIEW_NAME
 
 This statement shows a `CREATE VIEW' statement that will create the
 given view.
 
      mysql> SHOW CREATE VIEW v;
      +-------+----------------------------------------------------+
      | Table | Create Table                                       |
      +-------+----------------------------------------------------+
      | v     | CREATE VIEW `test`.`v` AS select 1 AS `a`,2 AS `b` |
      +-------+----------------------------------------------------+
 
 This statement was added in MySQL 5.0.1.
 

Info Catalog

(mysql.info.gz) SHOW CREATE TABLE

(mysql.info.gz) SHOW

(mysql.info.gz) SHOW DATABASES