Skip to main content
Skip to main content

views

Overview

Stores all view information.

Database

information_schema

Table Information

Column NameTypeDescription
TABLE_CATALOGvarchar(512)Catalog name
TABLE_SCHEMAvarchar(64)Database name
TABLE_NAMEvarchar(64)View name
VIEW_DEFINITIONvarchar(8096)View definition statement
CHECK_OPTIONvarchar(8)No practical effect, only for MySQL compatibility
IS_UPDATABLEvarchar(3)No practical effect, only for MySQL compatibility
DEFINERvarchar(77)No practical effect, only for MySQL compatibility
SECURITY_TYPEvarchar(7)No practical effect, only for MySQL compatibility
CHARACTER_SET_CLIENTvarchar(32)No practical effect, only for MySQL compatibility
COLLATION_CONNECTIONvarchar(32)No practical effect, only for MySQL compatibility