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:
TABLE_CATALOG
Aways def.
TABLE_SCHEMA
Database name containing the view.
This page is licensed: CC BY-SA / Gnu FDL
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.
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