The HSSYVIE table is used for SYSVIEWS views. The following table describes the columns in the HSSYSVIE table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| NAME | VARCHAR | 128 | 0 | Name of the object |
| CREATOR | VARCHAR | 128 | 0 | The schema of the object |
| SEQNO | SMALLINT | 4 | 0 | Sequence number of this row |
| CHECK | CHAR | 1 | 0 | Whether the WITH CHECK OPTION clause was specified in the CREATE VIEW statement |
| IBMREQD | CHAR | 1 | 0 | |
| TEXT | VARCHAR | 1500 | 0 | Text or portion of the text of the statement that was used to create the object |