sa_text_index_vocab_nchar system procedure

sa_text_index_vocab(
'indexname',
'tabname',
[ 'tabowner' ]
)

indexname Use this CHAR(128) parameter to specify the name of the text index.
tabname Use this CHAR(128) parameter to specify the name of the table on which the text index is built.
tabowner Use this optional CHAR(128) parameter to specify the owner of the table.

Column name	Data type	Description
term	NCHAR(60)	A term in the text index.
freq	BIGINT	The number of indexed values the term appears in.

The sa_text_index_vocab_nchar system procedure returns all terms that appear in a text index, and the total number of indexed values that each term appears in (which is less than the total number of occurrences if the term appears multiple times in some indexed values).

DBA authority, or SELECT permission on the indexed table is required.

None

sa_text_index_vocab_nchar system procedure

Syntax

Arguments

Result set

Remarks

Permissions

Side effects

See also