The HSSYVDE table is used for SYSVIEWDEP views. The following table describes the columns in the HSSYSVDE table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| BNAME | VARCHAR | 128 | 0 | Name of the object on which the view is dependent |
| BCREATOR | VARCHAR | 128 | 0 | Authorization ID of the owner of BNAME |
| BTYPE | CHAR | 1 | 0 | Type of object |
| DNAME | VARCHAR | 128 | 0 | Name of the view. |
| DCREATOR | VARCHAR | 128 | 0 | The schema of the view |
| IBMREQD | CHAR | 1 | 0 | |
| BSCHEMA | VARCHAR | 128 | 0 | Schema of BNAME |