Displays a list of text indexes for the current database.
sp_help_text_index [index_table_name]
is the name of the text index you want to display.
sp_help_text_index
Displays all indexes.
sp_help_text_index "i_blurbs"
Displays information about the text index i_blurbs.
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 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
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
Any user can execute sp_help_text_index.
