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:
|
hash_size | UNSIGNED SHORT | Stores the hash size used for index hashing. |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |