SQL Reference

OBJCAT.INDEXEXTENSIONDEP

Contains a row for each dependency that index extensions have on various database objects.

Table 110. OBJCAT.INDEXEXTENSIONDEP Catalog View

Column Name	Data Type	Nullable	Description
IESCHEMA	VARCHAR(128)		Qualified name of index extension which has dependencies on another object.
IENAME	VARCHAR(18)
BTYPE	CHAR(1)		Type of object that the index extension is dependent on: A = Alias F = Function instance or method instance J = Server definition O = "Outer" dependency on hierarchic SELECT privilege R = Structured type S = Summary table T = Table (not typed) U = Typed table V = View (not typed) W = Typed view X = Index extension
BSCHEMA	VARCHAR(128)		Qualified name of object depended on by the index extension (if BTYPE='F', this is the specific name of a function).
BNAME	VARCHAR(128)
TABAUTH	SMALLINT	Yes	If BTYPE='O', 'T', 'U', 'V', or 'W', encodes the privileges on the table (or view) that are required by a dependent trigger; otherwise null.