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 SHORTINT | Stores the hash size used for index hashing. |
Constraints See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |