Describes the indices of the tables and the type of the index.
|
Column |
Data Type |
N |
Description |
|---|---|---|---|
|
RECORD_NUMBER |
integer |
n |
unique identifier for this record of metadata |
|
INDEX_CATALOG |
identifier |
n |
index catalog |
|
INDEX_SCHEMA |
identifier |
n |
index schema |
|
INDEX_NAME |
identifier |
n |
index name |
|
TABLE_CATALOG |
identifier |
n |
table catalog |
|
TABLE_SCHEMA |
identifier |
n |
Table schema |
|
TABLE_NAME |
identifier |
n |
Table name |
|
SHORT_NAME |
char(2) |
n |
Internal Adabas identification of the index |
|
IS_MULTIPLE |
yes_no |
n |
Index is based on Adabas MU/PE field |
|
IS_MU_UQINDEX |
yes_no |
n |
Multiple index has the Adabas UQ option |
|
INDEX_DATA_TYPE |
char(128) |
y |
contains zero or more of the following attributes: INDEX, PRIMARY, UNIQUE |