Each row in the sysindex system table describes an index in the database.
| Column name | Column type | Description |
|---|---|---|
| table_id | INTEGER | A unique identifier for the table to which the index applies. |
| index_id | INTEGER | A unique identifier for an index. |
| index_name | VARCHAR(128) | The name of the index. |
| index_flags | TINY |
A bitwise combination of the following flags denoting the type of index and its persistence:
|
| index_data | INTEGER | Internal use only. |
PRIMARY KEY (table_id, index_id)
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |