INDEXCOLUMNS

Definition

The system table INDEXCOLUMNS contains detailed information about the indexes for which the current database user has privileges.

Structure

INDEXCOLUMNS

SCHEMANAME

CHAR(32)

Name of the schema of the index

OWNER

CHAR(32)

Name of the owner of the index

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 domain (BOOLEAN | CHAR | DATE | FIXED | FLOAT | INTEGER | SMALLINT | TIME | TIMESTAMP)

LEN

FIXED(4)

Length or precision of the definition of the column

CREATEDATE

DATE(10)

Creation date of the index

CREATETIME

TIME(8)

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

LONG

Comment on the index

See also:

Evaluating System Tables, INDEXCOLUMNS

SQL Reference Manual, Index Name (index_name)