Each row in the SYSTEXTIDXTAB system view describes a generated table that is part of a text index. The underlying system table for this view is ISYSTEXTIDXTAB.
For more information about the full text search feature, see Full text search.
| Column name | Column type | Description |
|---|---|---|
| index_id | UNSIGNED BIGINT | For internal use only. |
| sequence | UNSIGNED INT | For internal use only. |
| table_type | UNSIGNED INT | For internal use only. |
| table_id | UNSIGNED INT | For internal use only. |
PRIMARY KEY (index_id, sequence, table_type)
FOREIGN KEY (index_id, sequence) references SYS.ISYSTEXTIDX (index_id, sequence)
FOREIGN KEY (table_id) references SYS.ISYSTAB (table_id)
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |