Contains one or more rows for each view that is created.
Table 95. SYSCAT.VIEWS Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| VIEWSCHEMA | CHAR(8) |
| Name of the view or the name of a table used to define a summary table. |
| VIEWNAME | VARCHAR(18) |
| |
| DEFINER | CHAR(8) |
| Authorization ID of the creator of the view. |
| SEQNO | SMALLINT |
| Sequence number of this row; the first portion of the view is on row one, and successive rows have increasing values of SEQNO. |
| VIEWCHECK | CHAR(1) |
| States the type of view checking:
N=No check option L=Local check option C=Cascaded check option |
| READONLY | CHAR(1) |
|
Y=View is read-only because of its definition. N=View is not read-only. |
| VALID | CHAR(1) |
|
Y=View or summary table definition is valid.
X=View or summary table definition is inoperative;
must be re-created.
|
| FUNC_PATH | VARCHAR(254) |
| The SQL path of the view creator at the time the view was defined. When the view is used in data manipulation statements, this path must be used to resolve function calls in the view. SYSIBM for views created before Version 2. |
| TEXT | VARCHAR(3600) |
| Text or portion of the text of the CREATE VIEW statement. |