IF EXISTS (SELECT * FROM sys.fulltext_indexes fti WHERE fti.object_id = OBJECT_ID(N'[MyTable]')) ALTER FULLTEXT INDEX ON [MyTable] DISABLE GO IF EXISTS (SELECT * FROM sys.fulltext_indexes fti WHERE fti.object_id = OBJECT_ID(N'[MyTable]')) DROP FULLTEXT INDEX ON [MyTable] GO IF EXISTS (SELECT * FROM sysfulltextcatalogs ftc WHERE ftc.name = N'MyTable') DROP FULLTEXT CATALOG [MyTable]