20.15. The INFORMATION_SCHEMA VIEWS Table

MySQL 5.0

20.15. The INFORMATION_SCHEMA VIEWS Table

The table provides information about views in databases. You must have the privilege to access this table.

Name Name Remarks
 
   
   
   
   
   
   
   

Notes:

  • The column has most of what you see in the field that produces. Skip the words before and skip the words . 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 column always has a value of .

  • The column is if the view is updatable, if the view is not updatable.

  • The and columns were added in MySQL 5.0.14. indicates who defined the view. has a value of or .