Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite System Table Reference » UltraLite system tables

syscolumn system table Next Page

sysindex system table


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

Columns
Column nameDescriptionTypeData constraintIntegrity constraints

check_on_commit

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.

UNSIGNED INT

index_name

A unique identifier for the index.

UNSIGNED INT

NOT NULL

Primary key.

Foreign key references sysindex.

ixcol_count

The number of columns in the index.

UNSIGNED INT

NOT NULL

nullable

Only required if type is foreign. Indicates if nulls are allowed.

BIT

object_id

A unique identifier for an index.

UNSIGNED INT

NOT NULL

primary_index_id

Only required if type is foreign. Lists the identifier of the primary index.

UNSIGNED INT

primary_table_id

Only required if type is foreign. Lists the identifier of the primary table.

UNSIGNED INT

root_handle

For internal use only.

UNSIGNED INT

NOT NULL

table_id

A unique identifier for the table to which the index applies.

UNSIGNED INT

NOT NULL

Foreign key references systable.

type

The type of index. Can be one of:

  • primary
  • foreign
  • key
  • unique
  • index

SMALLINT (10)

NOT NULL

hash_size

Stores the hash size used for index hashing.

SHORT

See also