(mysql.info.gz) VIEWS Table

Info Catalog

(mysql.info.gz) ROUTINES Table

(mysql.info.gz) INFORMATION_SCHEMA Tables

(mysql.info.gz) Other INFORMATION_SCHEMA Tables

 
 21.1.15 The `INFORMATION_SCHEMA VIEWS' Table
 --------------------------------------------
 
 The `VIEWS' table provides information about views in databases.
 
 *Standard Name*               *`SHOW' name*          *Remarks*
 `TABLE_CATALOG'                                      `NULL'
 `TABLE_SCHEMA'                                       
 `TABLE_NAME'                                         
 `VIEW_DEFINITION'                                    
 `CHECK_OPTION'                                       
 `IS_UPDATABLE'                                       
 `INSERTABLE_INTO'                                    omit
 
 Notes:
 
    * There is a new privilege, `SHOW VIEW', without which you cannot
      see the `VIEWS' table.
 
    * 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'.  For
      example, if 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 is:
 
           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.
 
 

Info Catalog

(mysql.info.gz) ROUTINES Table

(mysql.info.gz) INFORMATION_SCHEMA Tables

(mysql.info.gz) Other INFORMATION_SCHEMA Tables