Information Schema VIEWS Table

Describes the VIEWS table in the Information Schema, which provides metadata about all views in the database, such as definition and check options.

The Information Schema VIEWS table contains information about views. The SHOW VIEW privilege is required to view the table.

It has the following columns:

Column	Description
TABLE_CATALOG	Aways def.
TABLE_SCHEMA	Database name containing the view.
TABLE_NAME	View table name.
VIEW_DEFINITION	Definition of the view.
CHECK_OPTION	YES if the WITH CHECK_OPTION clause has been specified, NO otherwise.
IS_UPDATABLE	Whether the view is updatable or not.
DEFINER	Account specified in the DEFINER clause (or the default when created).
SECURITY_TYPE	SQL SECURITY characteristic, either DEFINER or INVOKER.
CHARACTER_SET_CLIENT	The client character set when the view was created, from the session value of the character_set_client system variable.
COLLATION_CONNECTION	The client collation when the view was created, from the session value of the collation_connection system variable.
ALGORITHM	The algorithm used in the view. See View Algorithms.

Example

SELECT * FROM information_schema.VIEWS\G
*************************** 1. row ***************************
       TABLE_CATALOG: def
        TABLE_SCHEMA: test
          TABLE_NAME: v
     VIEW_DEFINITION: SELECT `test`.`t`.`qty` AS `qty`,`test`.`t`.`price` AS `price`,(`test`.`t`.`qty` * `test`.`t`.`price`) AS `value` FROM `test`.`t`
        CHECK_OPTION: NONE
        IS_UPDATABLE: YES
             DEFINER: root@localhost
       SECURITY_TYPE: DEFINER
CHARACTER_SET_CLIENT: utf8
COLLATION_CONNECTION: utf8_general_ci
           ALGORITHM: UNDEFINED

See Also

• CREATE VIEW

• ALTER VIEW

• DROP VIEW

• SHOW CREATE VIEWS

_{This page is licensed: CC BY-SA / Gnu FDL}