> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/server-usage/views/information-schema-views-table.md).

# Information Schema VIEWS Table

The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `VIEWS` table contains information about [views](/docs/server/server-usage/views.md). The `SHOW VIEW` [privilege](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md) is required to view the table.

It has the following columns:

| Column                 | Description                                                                                                                                                                                                                                                                                              |
| ---------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| TABLE\_CATALOG         | Always 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](/docs/server/reference/data-types/string-data-types/character-sets.md) when the view was created, from the session value of the [character\_set\_client](/docs/server/server-management/variables-and-modes/server-system-variables.md#character_set_client) system variable. |
| COLLATION\_CONNECTION  | The client [collation](/docs/server/reference/data-types/string-data-types/character-sets.md) when the view was created, from the session value of the [collation\_connection](/docs/server/server-management/variables-and-modes/server-system-variables.md#collation_connection) system variable.      |
| ALGORITHM              | The algorithm used in the view. See [View Algorithms](/docs/server/server-usage/views/view-algorithms.md).                                                                                                                                                                                               |

## Example

```sql
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

* [CREATE VIEW](/docs/server/server-usage/views/create-view.md)
* [ALTER VIEW](/docs/server/server-usage/views/alter-view.md)
* [DROP VIEW](/docs/server/server-usage/views/drop-view.md)
* [SHOW CREATE VIEWS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-view.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}