DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info) show-create-view

Info Catalog (mysql.info) show-create-table (mysql.info) show (mysql.info) show-databases
 
 13.5.4.7 `SHOW CREATE VIEW' Syntax
 ..................................
 
      SHOW CREATE VIEW VIEW_NAME
 
 This statement shows a `CREATE VIEW' statement that creates the given
 view.
 
      mysql> SHOW CREATE VIEW v;
      +------+----------------------------------------------------+
      | View | Create View                                        |
      +------+----------------------------------------------------+
      | v    | CREATE VIEW `test`.`v` AS select 1 AS `a`,2 AS `b` |
      +------+----------------------------------------------------+
 
 This statement was added in MySQL 5.0.1.
 
 Prior to MySQL 5.0.11, the output columns from this statement were
 shown as `Table' and `Create Table'.
 
 You can also obtain information about view objects from
 `INFORMATION_SCHEMA', which contains a `VIEWS' table. See 
 views-table.
 
Info Catalog (mysql.info) show-create-table (mysql.info) show (mysql.info) show-databases
automatically generated byinfo2html