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. |
| hash_size | UNSIGNED SHORT | The hash size used for index hashing. |
Constraints |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0 |