sysindex system table

Each row in the sysindex system table describes an index in the database.

Column name Column type Description
table_id INTEGER A unique identifier for the table to which the index applies.
index_id INTEGER A unique identifier for an index.
index_name VARCHAR(128) The name of the index.
index_flags TINY

A bitwise combination of the following flags denoting the type of index and its persistence:

  • 0x01   Unique key.

  • 0x02   Unique index.

  • 0x04   Index is persistent.

  • 0x08   Primary key.

index_data INTEGER Internal use only.
Constraints

PRIMARY KEY (table_id, index_id)