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