sysindex system table

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

Column name Column type Description
check_on_commit UNSIGNED INT 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 UNSIGNED INT 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 SMALLINT (10)

The type of index. Can be one of:

  • primary
  • foreign
  • key
  • unique
  • index
hash_size SHORT Stores the hash size used for index hashing.
Constraints

PRIMARY KEY (table_id, object_id)

FOREIGN KEY( table_id ) REFERENCES systable( object_id )

See also