Object documentationINDEXCOLUMNS Locate this document in the navigation structure

 

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

Structure

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

More Information

Evaluating System Tables, INDEXCOLUMNS

SQL Reference Manual, Index Name (index_name)