sp_drop_text_index

Description

Drops the index table and text indexes.

Syntax

sp_drop_text_index  "table_name.index_table_name"      [,"table_name.index_table_name"...]

Parameters

table_name

– is the name of the table associated with the text indexes you are dropping. table_name has the form [dbname.[owner.]]table, where:

index_table_name

– is the name of the index table and text index you are dropping. index_table_name has the form [dbname.[owner.]]index.

Examples

Example 1

sp_drop_text_index "blurbs.i_blurbs"

Drops the index table and text index associated with the blurbs table.

Usage

Messages

Permissions

Any user can execute sp_drop_text_index.