Wednesday, 25 December 2013

Drop full text index SQL

From time to time you may have to drop a full text index if so the following may be of intrest.

Get the catalog
SELECT name
FROM sys.fulltext_catalogs;

Get the table

sp_help_fulltext_tables;

drop the table catalogs
DROP FULLTEXT INDEX ON  tablename

This may need a bit of work as i have just copied it from some notes i made but i should point you in the right direction.

No comments:

Post a Comment

Samsung Android Keyboard

  If you have a Samsung phone or pad and the keyboard is set to Google give the Samsung one a try. Just go into the keyboard settings and ...