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

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?