Each row in the sysindex system table describes an index in the database.
| Column name | Column type | Description |
|---|---|---|
| table_id | UNSIGNED INTEGER | A unique identifier for the table to which the index applies. |
| index_id | UNSIGNED 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 | UNSIGNED INTEGER | Internal use only. |
Constraints |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |