SQL Reference

SYSCAT.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 95. SYSCAT.VIEWDEP Catalog View

Column Name	Data Type	Nullable	Description
VIEWSCHEMA	VARCHAR(128)		Name of the view or the name of a summary table having dependencies on a base table.
VIEWNAME	VARCHAR(128)
DTYPE	CHAR(1)		S = Summary table V = View (untyped) W = Typed view
DEFINER	VARCHAR(128)	Yes	Authorization ID of the creator of the view.
BTYPE	CHAR(1)		Type of object BNAME: A = Alias F = Function instance N = Nickname O = Privilege dependency on all subtables or subviews in a table or view hierarchy I = Index if recording dependency on a base table R = Structured type S = Summary table T = Table U = Typed table V = View W = Typed view
BSCHEMA	VARCHAR(128)		Qualified name of object depended on by the view.
BNAME	VARCHAR(128)
TABAUTH	SMALLINT	Yes	If BTYPE= O, S, T, U, V, W then encodes the privileges on the underlying table or view that this view depends on. Otherwise null.

[ DB2 List of Books | Search the DB2 Books ]