SQL Reference

OBJCAT.VIEWDEP

Contains a row for every dependency of a view or a summary table on some other object. Also encodes how privileges on this view depend on privileges on underlying tables and views.

Table 94. OBJCAT.VIEWDEP Catalog View

Column Name Data Type Nullable Description
VIEWSCHEMA CHAR(8)
Name of the view or the name of a summary table having dependancies on a base table.
VIEWNAME VARCHAR(18)
DEFINER CHAR(8) Yes Authorization ID of the creator of the view.
BTYPE CHAR(1)
Type of object BNAME:

A=Alias
F=Function instance
H=Table or view hierarchy
I=Index if recording dependency on a base table
R=Structured type
S=Summary table
T=Table
V=View

BSCHEMA CHAR(8)
Qualified name of object depended on by the view.
BNAME VARCHAR(18)
TABAUTH SMALLINT Yes Encodes the privileges on the underlying table or view that this view depends on. Otherwise null.

Column Name	Data Type	Nullable	Description
VIEWSCHEMA	CHAR(8)		Name of the view or the name of a summary table having dependancies on a base table.
VIEWNAME	VARCHAR(18)
DEFINER	CHAR(8)	Yes	Authorization ID of the creator of the view.
BTYPE	CHAR(1)		Type of object BNAME: A=Alias F=Function instance H=Table or view hierarchy I=Index if recording dependency on a base table R=Structured type S=Summary table T=Table V=View
BSCHEMA	CHAR(8)		Qualified name of object depended on by the view.
BNAME	VARCHAR(18)
TABAUTH	SMALLINT	Yes	Encodes the privileges on the underlying table or view that this view depends on. Otherwise null.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]