Each row in the SYSTEXTIDX system view describes one text index. The underlying system table for this view is ISYSTEXTIDX.
For more information about the full text search feature, see Full text searching.
| Column name | Column 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 time of the last refresh. |
PRIMARY KEY (index_id, sequence)
FOREIGN KEY (index_id) references SYS.ISYSOBJECT (object_id)
FOREIGN KEY (text_config) references SYS.ISYSTEXTCONFIG (object_id)
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |