SYSIBM.SYSVIEWDEP table

The SYSIBM.SYSVIEWDEP table records the dependencies of views on tables, functions, and other views.

Column name Data type Description Use
BNAME
VARCHAR(128)
NOT NULL
 Name of the object on which the view is dependent. If the object type is a function (BTYPE='F'), the name is the specific name of the function. G
BCREATOR
VARCHAR(128)
NOT NULL
 Authorization ID of the owner of BNAME. G
BTYPE
CHAR(1)
NOT NULL
 Type of object:
F
Function
Start of changeGEnd of change
Start of changeCreated global temporary tableEnd of change
M
Materialized query table
T
Table
V
View
Start of changeWEnd of change
Start of changeSYSTEM_TIME periodEnd of change
Start of changeZEnd of change
Start of changeBUSINESS_TIME periodEnd of change
 G
DNAME
VARCHAR(128)
NOT NULL
 Name of the view. G
DCREATOR
VARCHAR(128)
NOT NULL
 The schema of the view. G
IBMREQD
CHAR(1)
NOT NULL
 A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies.

 G
BSCHEMA
VARCHAR(128)
NOT NULL WITH
DEFAULT
 Schema of BNAME. G
DTYPE
CHAR(1)
NOT NULL
Type of table:
F
SQL function
M
Materialized query table
V
View
 G
DOWNER
VARCHAR(128)
NOT NULL WITH
DEFAULT
 Authorization ID of the owner of the view, blank for views that were created in a DB2® release prior to Version 9. G
OWNERTYPE
CHAR(1)
NOT NULL WITH
DEFAULT
 Indicates the type of owner:
blank
Authorization ID
L
Role
 G