DB2 Universal Database for iSeries SQL Reference

VIEWS

The VIEWS view contains one row for each view. The following table describes the columns in the view:

Table 163. VIEWS view

Column Name Data Type Description
TABLE_CATALOG VARCHAR(128) Relational database name
TABLE_SCHEMA VARCHAR(128) Name of the SQL schema that contains the view.
TABLE_NAME VARCHAR(128) Name of the view.
VIEW_DEFINITION CLOB(2M)
Nullable
The query expression portion of the CREATE VIEW statement.
CHECK_OPTION VARCHAR(8) The check option used on the view

NONE
No check option was specified

LOCAL
The local option was specified

CASCADED
The cascaded option was specified
IS_UPDATABLE VARCHAR(3) Specifies if the view is updatable:

YES
The view is updatable

NO
The view is read-only


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]