SYSVIEWDEP catalog table

The SYSVIEWDEP table records the dependencies of views, SQL function tables, and materialized query tables on other objects. The schema is SYSIBM.

Table 1. SYSIBM.SYSVIEWDEP table column descriptions
Column name Data type Description Use
BNAME
VARCHAR(128)
NOT NULL
 Start of changeName of the object on which the view, SQL function, or materialized query table is dependent. If the object type is a function (BTYPE='F'), the name is the specific name of the function.End of change G
BCREATOR
VARCHAR(128)
NOT NULL
 Authorization ID of the owner of BNAME. G
BTYPE
CHAR(1)
NOT NULL
 Type of object:
F
Function
G
Created global temporary table
M
Materialized query table
T
Table
V
View
W
SYSTEM_TIME period
Z
BUSINESS_TIME period
 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 was provided with the Db2 product code. 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 dependent object:
F
SQL function
M
Materialized query table
V
View
 G
DOWNER
VARCHAR(128)
NOT NULL WITH
DEFAULT
 Start of changeAuthorization ID of the dependent object. Blank for views that were created in a Db2 release prior to Version 9.End of change G
OWNERTYPE
CHAR(1)
NOT NULL WITH
DEFAULT
 Indicates the type of owner:
blank
Authorization ID
L
Role
 G
SYS_START
TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS ROW BEGIN
 Reserved for future IBM® use. G
SYS_END
TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS ROW END
 Reserved for future IBM use. G
TRANS_START
TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS TRANSACTION
START ID
 Reserved for future IBM use. G