(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