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 |