VIEWS

The VIEWS table provides a list of views that the current user has visibility of.

  1. DESC TABLE INFORMATION_SCHEMA.VIEWS;
  1. +----------------------+---------+------+------+---------+---------------+
  2. | Column               | Type    | Key  | Null | Default | Semantic Type |
  3. +----------------------+---------+------+------+---------+---------------+
  4. | table_catalog        | String  |      | NO   |         | FIELD         |
  5. | table_schema         | String  |      | NO   |         | FIELD         |
  6. | table_name           | String  |      | NO   |         | FIELD         |
  7. | view_definition      | String  |      | NO   |         | FIELD         |
  8. | check_option         | String  |      | YES  |         | FIELD         |
  9. | is_updatable         | Boolean |      | YES  |         | FIELD         |
  10. | definer              | String  |      | YES  |         | FIELD         |
  11. | security_type        | String  |      | YES  |         | FIELD         |
  12. | character_set_client | String  |      | YES  |         | FIELD         |
  13. | collation_connection | String  |      | YES  |         | FIELD         |
  14. +----------------------+---------+------+------+---------+---------------+

The columns in table:

  • table_catalog: The name of the catalog to which the view belongs.
  • table_schema: The name of the database to which the view belongs.
  • table_name: The view name.
  • view_definition: The definition of view, which is made by the SELECT statement when the view is created.
  • check_option: Doesn’t support, is always NULL.
  • is_updatable: Whether UPDATE/INSERT/DELETE is applicable to the view, always NO.
  • definer: The name of the user who creates the view.
  • security_type: Doesn’t support, is always NULL.
  • character_set_client: The value of the character_set_client session variable when the view is created, is always utf8.
  • collation_connection: The value of the collation_connection session variable when the view is created, is always utf8_bin.