SYSTEXTIDXTAB system view

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 searching.

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.
Constraints on underlying system table

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)