(mysql.info) views-table
Info Catalog
(mysql.info) routines-table
(mysql.info) information-schema
(mysql.info) triggers-table
20.15 The `INFORMATION_SCHEMA VIEWS' Table
==========================================
The `VIEWS' table provides information about views in databases. You
must have the `SHOW VIEW' privilege to access this table.
*`INFORMATION_SCHEMA' Name* *`SHOW' Name* *Remarks*
`TABLE_CATALOG' `NULL'
`TABLE_SCHEMA'
`TABLE_NAME'
`VIEW_DEFINITION'
`CHECK_OPTION'
`IS_UPDATABLE'
`DEFINER'
`SECURITY_TYPE'
Notes:
* The `VIEW_DEFINITION' column has most of what you see in the
`Create Table' field that `SHOW CREATE VIEW' produces. Skip the
words before `SELECT' and skip the words `WITH CHECK OPTION'.
Suppose that the original statement was:
CREATE VIEW v AS
SELECT s2,s1 FROM t
WHERE s1 > 5
ORDER BY s1
WITH CHECK OPTION;
Then the view definition looks like this:
SELECT s2,s1 FROM t WHERE s1 > 5 ORDER BY s1
* The `CHECK_OPTION' column always has a value of `NONE'.
* The `IS_UPDATABLE' column is `YES' if the view is updatable, `NO'
if the view is not updatable.
* The `DEFINER' and `SECURITY_TYPE' columns were added in MySQL
5.0.14. `DEFINER' indicates who defined the view. `SECURITY_TYPE'
has a value of `DEFINER' or `INVOKER'.
Info Catalog
(mysql.info) routines-table
(mysql.info) information-schema
(mysql.info) triggers-table
automatically generated byinfo2html