>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] >Shouldn't be the last one sys.fulltext_catalogs, for consistency ?