The SYSVIEWDEP view records the dependencies of views on tables, including the views of the SQL catalog.
The following table describes the columns in the SYSVIEWDEP view:
| Column name | System Column Name | Data Type | Description |
|---|---|---|---|
| VIEW_NAME | DNAME | VARCHAR(128) | Name of the view. This is the SQL view name if it exists; otherwise, it is the system view name. |
| VIEW_OWNER | DCREATOR | VARCHAR(128) | Owner of the view |
| OBJECT_NAME | ONAME | VARCHAR(128) | Name of the object the view is dependent on. |
| OBJECT_SCHEMA | OSCHEMA | VARCHAR(128) | Name of the SQL schema that contains the object the view is dependent on. |
| OBJECT_TYPE | OTYPE | CHAR(24) | Type of object the view was based
on:
|
| VIEW_SCHEMA | DDBNAME | VARCHAR(128) | Name of the schema of the view. |
| SYSTEM_VIEW_NAME | SYS_VNAME | CHAR(10) | System View name |
| SYSTEM_VIEW_SCHEMA | SYS_VDNAME | CHAR(10) | System View schema |
| SYSTEM_TABLE_NAME | SYS_TNAME | CHAR(10) Nullable |
System Table name. Contains the null value if the object is a function or distinct type. |
| SYSTEM_TABLE_SCHEMA | SYS_DNAME | CHAR(10) Nullable |
System Table schema. Contains the null value if the object is a function or distinct type. |
| TABLE_NAME | BNAME | VARCHAR(128) Nullable |
Name of the table or view the view
is dependent on. This is the SQL view name if it exists; otherwise,
it is the system view name. Contains the null value if the object is a function or distinct type. |
| TABLE_OWNER | BCREATOR | VARCHAR(128) Nullable |
Owner of the table or view the view
is dependent on. Contains the null value if the object is a function or distinct type. |
| TABLE_SCHEMA | BDBNAME | VARCHAR(128) Nullable |
Name of the SQL schema that contains
the table or view the view is dependent on. Contains the null value if the object is a function or distinct type. |
| TABLE_TYPE | BTYPE | CHAR(1) Nullable |
Type of object the view was based
on:
Contains the null value if the object is a function or distinct type. |
| IASP_NUMBER | IASPNUMBER | SMALLINT | Specifies the independent auxiliary storage pool (IASP) number. |
| PARM_SIGNATURE | SIGNATURE | VARCHAR(10000) Nullable |
This column identifies the routine
signature. Contains the null value if the object is not a routine. |