sp_help_text_index

Description

Displays a list of text indexes for the current database.

Syntax

sp_help_text_index [index_table_name]

Parameters

Examples

Example 1

Displays all indexes:

sp_help_text_index

Example 2

Displays information about the text index i_blurbs:

sp_help_text_index "i_blurbs"

Usage

• sp_help_text_index is available only with Enhanced Full-Text Search Specialty Data Store.

• If you the index_table_name parameter, information about that text index is displayed. This information includes the name of the text index, the name of the Verity collection for the index, the name of the source table, the name of the IDENTITY or primary key column, and the name of the Enhanced Full-Text Search engine that created the index.

• If index_table_name is omitted, a list of all text indexes in the current database is displayed

Messages

• No text indexes found in database ‘database_name.’

• Text index ‘index_name’ does not exist in database ‘database_name.’

• Object must be in the current database

Permissions

Any user can execute sp_help_text_index.