VIEWS

Information on all the views for which the current authorization identifier has privileges.

Column name

Data type

Contents

TABLE_CATALOG

CHAR (18)

Database name

TABLE_SCHEMA

CHAR (31)

Name of the schema to which the view belongs

TABLE_NAME

CHAR (31)

Name of the view

VIEW_DEFINITION

VARCHAR
(32000)

Query expression that defines the view if the
current authorization identifier owns the
schema

NULL value in all other cases

CHECK_OPTION

VARCHAR (8)

NONE

No check option set

CASCADED

Check option set

IS_UPDATABLE

VARCHAR (3)

YES	View is updatable
NO	View is not updatable

Table 103: VIEWS view of the INFORMATION_SCHEMA