views
Overview
Stores all view information.
Database
information_schema
Table Information
Column Name | Type | Description |
---|---|---|
TABLE_CATALOG | varchar(512) | Catalog name |
TABLE_SCHEMA | varchar(64) | Database name |
TABLE_NAME | varchar(64) | View name |
VIEW_DEFINITION | varchar(8096) | View definition statement |
CHECK_OPTION | varchar(8) | No practical effect, only for MySQL compatibility |
IS_UPDATABLE | varchar(3) | No practical effect, only for MySQL compatibility |
DEFINER | varchar(77) | No practical effect, only for MySQL compatibility |
SECURITY_TYPE | varchar(7) | No practical effect, only for MySQL compatibility |
CHARACTER_SET_CLIENT | varchar(32) | No practical effect, only for MySQL compatibility |
COLLATION_CONNECTION | varchar(32) | No practical effect, only for MySQL compatibility |