sysindex system table

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

Column name Column type Description
check_on_commit BIT Indicates when referential integrity is checked to ensure there is a matching primary row for every foreign key. It is only required if type is foreign.
index_name VARCHAR(128) The name of the index.
ixcol_count UNSIGNED INT The number of columns in the index.
nullable BIT Only required if type is foreign. Indicates if nulls are allowed.
object_id UNSIGNED INT A unique identifier for an index.
primary_index_id UNSIGNED INT Only required if type is foreign. Lists the identifier of the primary index.
primary_table_id UNSIGNED INT Only required if type is foreign. Lists the identifier of the primary table.
root_handle UNSIGNED INT For internal use only.
table_id UNSIGNED INT A unique identifier for the table to which the index applies.
type VARCHAR(10)

The type of index. Can be one of:

  • primary
  • foreign
  • key
  • unique
  • index
hash_size UNSIGNED SHORTINT Stores the hash size used for index hashing.
 Constraints
 See also