Purpose
The information_schema.VIEWS view displays information about views.
Note
This view is introduced since OceanBase Database V1.4.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_CATALOG | varchar(64) | NO | The name of the catalog to which the table belongs. |
| TABLE_SCHEMA | varchar(128) | NO | The name of the database. |
| TABLE_NAME | varchar(256) | NO | The name of the table. |
| VIEW_DEFINITION | longtext | NO | The view definition. |
| CHECK_OPTION | varchar(8) | NO | The check option. |
| IS_UPDATABLE | varchar(3) | NO | Indicates whether the view can be updated. |
| DEFINER | varchar(288) | NO | The username of the user who created the view. |
| SECURITY_TYPE | varchar(7) | NO | The security type. |
| CHARACTER_SET_CLIENT | varchar(64) | NO | The value of the session variable character_set_client when the view was created. |
| COLLATION_CONNECTION | varchar(64) | NO | The value of the session variable collation_connection when the view was created. |