VIEWS
The VIEWS table provides a list of views that the current user has visibility of.
sql
DESC TABLE INFORMATION_SCHEMA.VIEWS;DESC TABLE INFORMATION_SCHEMA.VIEWS;sql
+----------------------+---------+------+------+---------+---------------+
| Column | Type | Key | Null | Default | Semantic Type |
+----------------------+---------+------+------+---------+---------------+
| table_catalog | String | | NO | | FIELD |
| table_schema | String | | NO | | FIELD |
| table_name | String | | NO | | FIELD |
| view_definition | String | | NO | | FIELD |
| check_option | String | | YES | | FIELD |
| is_updatable | Boolean | | YES | | FIELD |
| definer | String | | YES | | FIELD |
| security_type | String | | YES | | FIELD |
| character_set_client | String | | YES | | FIELD |
| collation_connection | String | | YES | | FIELD |
+----------------------+---------+------+------+---------+---------------++----------------------+---------+------+------+---------+---------------+
| Column | Type | Key | Null | Default | Semantic Type |
+----------------------+---------+------+------+---------+---------------+
| table_catalog | String | | NO | | FIELD |
| table_schema | String | | NO | | FIELD |
| table_name | String | | NO | | FIELD |
| view_definition | String | | NO | | FIELD |
| check_option | String | | YES | | FIELD |
| is_updatable | Boolean | | YES | | FIELD |
| definer | String | | YES | | FIELD |
| security_type | String | | YES | | FIELD |
| character_set_client | String | | YES | | FIELD |
| collation_connection | String | | YES | | FIELD |
+----------------------+---------+------+------+---------+---------------+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 theSELECTstatement when the view is created.check_option: Doesn't support, is alwaysNULL.is_updatable: WhetherUPDATE/INSERT/DELETEis applicable to the view, alwaysNO.definer: The name of the user who creates the view.security_type: Doesn't support, is alwaysNULL.character_set_client: The value of thecharacter_set_clientsession variable when the view is created, is alwaysutf8.collation_connection: The value of thecollation_connectionsession variable when the view is created, is alwaysutf8_bin.