Lists all terms that appear in an NCHAR text index, and the total number of indexed values that each term appears in. For CHAR text indexes, see sa_text_index_vocab system procedure.
Syntaxsa_text_index_vocab( 'indexname', 'tabname', [ 'tabowner' ] )
Argumentsindexname 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.
Result set| 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. |
RemarksThe 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).
PermissionsDBA authority, or SELECT permission on the indexed table is required.
Side effectsNone
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |