Information Schema VIEWS Table
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
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?