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. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.