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:
|
| hash_size | SHORT | Stores the hash size used for index hashing. |
PRIMARY KEY (table_id, object_id)
FOREIGN KEY( table_id ) REFERENCES systable( object_id )
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |