Drops the index table and text indexes.
sp_drop_text_index "table_name.index_table_name" [,"table_name.index_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:
dbname is the name of the database containing the table.
owner is the name of the owner of the table.
table is the name of the table.
is the name of the index table and text index you are dropping. index_table_name has the form [dbname.[owner.]]index.
Drops the index table and text index associated with the blurbs table:
sp_drop_text_index "blurbs.i_blurbs"
First, sp_drop_text_index issues a remote procedure call (RPC) to the Enhanced Full-Text Search engine to delete the Verity collection. Then, it removes the associated entries from the vesaux and vesauxcol tables, drops the index table, and removes the index table object definition.
Up to 255 indexes can be specified in a single sp_drop_text_index request.
If database and owner are not specified, the current owner and database are used.
Cannot run sp_drop_text_index from within a transaction.
Index ‘index_name’ is not a text index.
‘parameter_name’ is not a valid name.
Server name ‘server_name’ does not exist in sysservers.
Unable to drop index table ‘table_name’. This table must be dropped manually.
User ‘user_name’ is not a valid user in the ‘database_name’ database.
vs_drop_index failed with code ‘code_name’.
Any user can execute sp_drop_text_index.
