sa_text_index_vocab_nchar(
indexname
, tabname
[, tabowner ]
)

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

You must have SELECT privilege on the indexed table, or have the SELECT ANY TABLE system privilege.

None

• sa_text_index_vocab system procedure
• Full text search
• Term and phrase search
• DROP TEXT INDEX statement
• REFRESH TEXT INDEX statement
• TRUNCATE TEXT INDEX statement
• sa_refresh_text_indexes system procedure
• SYSTEXTIDX system view

The following example builds a text index called VocabNTxtIdx on the NProducts.Description column. The NProducts table is a version of the Products table with NCHAR columns instead of CHAR columns.

CREATE TEXT INDEX VocabNTxtIdx2 ON NProducts( Description );

The next statement executes the sa_text_index_vocab_nchar system procedure to return all the terms that appear in the text index.

SELECT * FROM sa_text_index_vocab_nchar( 'VocabNTxtIdx2', 'NProducts' );