Term Management in a TEXT Index

You can use stored procedures to break strings into terms, to discover how many terms are in the TEXT index and their position, and to display statistical information about the TEXT indexes.

• sa_char_terms System Procedure
  Breaks a CHAR string into terms and returns each term as a row along with its position.
• sa_nchar_terms System Procedure
  Breaks an NCHAR string into terms and returns each term as a row along with its position.
• sa_text_index_stats System Procedure
  Returns statistical information about the TEXT indexes in the database.
• sa_text_index_vocab System Procedure
  Lists all terms that appear in a TEXT index, and the total number of indexed values in which each term appears.