INDEXCOLUMNS

SCHEMANAME

CHAR(32)

Name of the table schema

OWNER

CHAR(32)

Name of the owner of the table

TABLENAME

CHAR(32)

Name of the table

INDEXNAME

CHAR(32)

Name of the index

FILEID

CHAR(8) BYTE

ID of the index file

TYPE

CHAR(6)

Index type (UNIQUE | NULL)

COLUMNNAME

CHAR(32)

Name of the column

SORT

CHAR(4)

Sort sequence for the column (ASC | DESC)

COLUMNNO

FIXED(4)

Number of the column in the index

DATATYPE

CHAR(10)

Data type of the column (BOOLEAN | CHAR | DATE | FIXED | FLOAT | INTEGER | SMALLINT | TIME | TIMESTAMP)

LEN

FIXED(4)

Length or accuracy of column definition

CREATEDATE

DATE

Creation date of the index

CREATETIME

TIME

Creation time of the index

INDEX_USED

FIXED(10)

Frequency of use in search operations

FILESTATE

CHAR(20)

Status of the index (OK | BAD | MISSING)

DISABLED

CHAR(3)

Index not active for search operations (YES | NO)

COMMENT

CLOB

Comment on the index