sp_help_text_index

Description

Displays a list of text indexes for the current database.

Syntax

sp_help_text_index [index_table_name]

Parameters

index_table_name

is the name of the text index you want to display.

Examples

Example 1

sp_help_text_index

Displays all indexes.

Example 2

sp_help_text_index "i_blurbs"

Displays information about the text index i_blurbs.

Usage

Messages

Permissions

Any user can execute sp_help_text_index.