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

• CREATE VIEW

• ALTER VIEW

• DROP VIEW

• SHOW CREATE VIEWS

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