# VIEWS

This view contains information about the views in a cluster.

| Column Name            | Description                                                                                                                            |
| ---------------------- | -------------------------------------------------------------------------------------------------------------------------------------- |
| `TABLE_CATALOG`        | The related catalog for a given view.                                                                                                  |
| `TABLE_SCHEMA`         | The related schema (database) for a given view.                                                                                        |
| `TABLE_NAME`           | The name of a given view.                                                                                                              |
| `VIEW_DEFINITION`      | The SQL statement used to define a given view.                                                                                         |
| `CHECK_OPTION`         | This column exists for MySQL compatibility and is always`NONE`.                                                                        |
| `IS_UPDATABLE`         | Whether or not a given view can be updated.                                                                                            |
| `DEFINER`              | The user who created a given view.                                                                                                     |
| `SECURITY_TYPE`        | This value is always`DEFINER`.                                                                                                         |
| `CHARACTER_SET_CLIENT` | This column is only included for command compatibility with MySQL. The value of this variable cannot be guaranteed.                    |
| `COLLATION_CONNECTION` | The session setting for the`collation_connection`engine variable when a given view was created.                                        |
| FLAGS                  | Whether the view is a Table Valued Function (TVF).`IS_TABLE_VALUED_FUNCTION`indicates the view is a TVF. Otherwise the value is blank. |

***

Modified at: May 21, 2025

Source: [/db/v9.1/reference/information-schema-reference/cluster-component/views/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/views/)

(An index of the documentation is available at /llms.txt)