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 | VARGRAPHIC(5000) CCSID
1200Nullable ![]() |
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. |
| IS_DELETABLE | DELETES | CHAR(1) Nullable |
Specifies if the view is deletable:
|
| VIEW_DEFINER | DEFINER | VARCHAR(128) | Name of the user that defined the view. |
| ROUNDING_MODE | DECFLTRND | CHAR(1) Nullable |
Indicates the DECFLOAT rounding mode of the
view:
Contains the null value if the view does not have an expression that references a DECFLOAT column, function, or constant. |