Table_Indexes View
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