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.
sp_drop_text_index "blurbs.i_blurbs"
Drops the index table and text index associated with the blurbs table.
First, the sp_drop_text_index system procedure issues a remote procedure call (RPC) to the 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.
Can’t 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.
