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.

Column name	Data 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)

SYSTEXTIDXTAB system view

Constraints on underlying system table

See also