Each row represents a dependency of an index on some other object. The index depends on an object of type BTYPE and name BNAME, so a change to the object affects the index.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
INDSCHEMA | VARCHAR (128) | Schema name of the index. | |
INDNAME | VARCHAR (128) | Unqualified name of the index. | |
BTYPE | CHAR (1) | Type of object on which there is a dependency. Possible values
are:
|
|
BSCHEMA | VARCHAR (128) | Schema name of the object on which there is a dependency. | |
BMODULENAME | VARCHAR(128) | Y | Unqualified name of the module to which the object on which a dependency belongs. The null value if not a module object. |
BNAME | VARCHAR (128) | Unqualified name of the object on which there is a dependency. For routines (BTYPE = 'F'), this is the specific name. | |
BMODULEID | INTEGER | Y | Identifier for the module of the object on which there is a dependency. |
TABAUTH | SMALLINT | Y | If BTYPE = 'O', 'S', 'T', 'U', 'V', 'W', or 'v', encodes the privileges on the table or view that are required by the dependent index; the null value otherwise. |