SQL Reference

SYSCAT.INDEXDEP

Each row represents a dependency of an index on some other object.

Table 66. SYSCAT.INDEXDEP Catalog View

Column Name Data Type Nullable Description
INDSCHEMA VARCHAR(128)
Qualified name of the index which has dependencies on another object.
INDNAME VARCHAR(18)
BTYPE CHAR(1)
Type of object that the index is dependent on.

A = Alias
F = Function instance
O = Privilege dependency on all subtables or subviews in a table or view hierarchy
R = Structured type
S = Summary table
T = Table
U = Typed table
V = View
W = Typed view
X = Index extension

BSCHEMA VARCHAR(128)
Qualified name of the object that the index has a dependency on.
BNAME VARCHAR(128)
TABAUTH SMALLINT Yes If BTYPE = O, S, T, U, V or W then it encodes the privileges on the table or view that are required by the dependent index. Otherwise null.

Column Name	Data Type	Nullable	Description
INDSCHEMA	VARCHAR(128)		Qualified name of the index which has dependencies on another object.
INDNAME	VARCHAR(18)
BTYPE	CHAR(1)		Type of object that the index is dependent on. A = Alias F = Function instance O = Privilege dependency on all subtables or subviews in a table or view hierarchy R = Structured type S = Summary table T = Table U = Typed table V = View W = Typed view X = Index extension
BSCHEMA	VARCHAR(128)		Qualified name of the object that the index has a dependency on.
BNAME	VARCHAR(128)
TABAUTH	SMALLINT	Yes	If BTYPE = O, S, T, U, V or W then it encodes the privileges on the table or view that are required by the dependent index. Otherwise null.

[ Top of Page | Previous Page | Next Page ]