The SYSVIEWS view contains one row for each view in the SQL schema,
including the views of the SQL catalog. The following table describes
the columns in the SYSVIEWS view:
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
TABLE_NAME | NAME | VARCHAR(128) | Name of the view. This is the SQL view name if it exists; otherwise, it is the system view name. |
VIEW_OWNER | CREATOR | VARCHAR(128) | Owner of the view |
SEQNO | SEQNO | INTEGER | Sequence number of this row; will always be 1. |
CHECK_OPTION | CHECK | CHAR(1) | The check option used on the view
|
VIEW_DEFINITION | TEXT |
VARCHAR(10000) Nullable | The query expression portion of the CREATE VIEW statement.
Contains the null value if the view definition cannot be contained in the column without truncation. |
IS_UPDATABLE | UPDATES | CHAR(1) | Specifies if the view is updatable:
|
TABLE_SCHEMA | DBNAME | VARCHAR(128) | Name of the SQL schema that contains the view. |
SYSTEM_VIEW_NAME | SYS_VNAME | CHAR(10) | System View name |
SYSTEM_VIEW_SCHEMA | SYS_VDNAME | CHAR(10) | System View schema name |
IS_INSERTABLE_INTO | INSERTABLE | VARCHAR(3) | Identifies whether an INSERT is allowed on the view.
|
IASP_NUMBER | IASPNUMBER | SMALLINT | Specifies the independent auxiliary storage pool (IASP) number. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.