Each row in the SYSTEXTIDX system view describes one text index. The underlying system table for this view is ISYSTEXTIDX.
| Column name | Data type | Description |
|---|---|---|
| index_id | UNSIGNED BIGINT | The object ID of the text index in SYSIDX. |
| sequence | UNSIGNED INT | For internal use only. |
| status | UNSIGNED INT | For internal use only. |
| text_config | UNSIGNED BIGINT | The object ID of the text configuration object in SYSTEXTCONFIG. |
| next_handle | UNSIGNED INT | For internal use only. |
| last_handle | UNSIGNED INT | For internal use only. |
| deleted_length | UNSIGNED BIGINT | The total size of deleted indexed values in the text index. |
| pending_length | UNSIGNED BIGINT | The total size of indexed values that will be added to the text index at the next refresh. |
| refresh_type | TINYINT |
The type of refresh. One of:
|
| refresh_interval | UNSIGNED INT | The AUTO REFRESH interval, in minutes. |
| last_refresh | TIMESTAMP | The local time of the last refresh. |
| last_refresh_utc | TIMESTAMP WITH TIME ZONE | The UTC time of the last refresh. |
Constraints on underlying system table See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |