Lists all terms that appear in a text index, and the total number of indexed values that each term appears in.

Syntax

sa_text_index_vocab(
'text-index-name',
'table-name',
'table-owner'
)

Arguments

Result set

Remarks

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

Permissions

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

Side effects

None

See also

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

Example

The following example builds a text index called VocabTxtIdx on the Products.Description column in the sample database. The next statement executes the sa_text_index_vocab system procedure to return all the terms that appear in the text index.

CREATE TEXT INDEX VocabTxtIdx2 ON Products( Description );
SELECT * 
   FROM sa_text_index_vocab( 'VocabTxtIdx2', 'Products', 'DBA' );