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	Name 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.	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	Authorization ID of the dependent object. 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
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