>Not tested suggestion. You can use sys.fulltext_indexes catalog view to get the list of indexes and drop them. After that you can drop catalogs using list from sys.fulltext_catalogs

Thanks, removing the indexes and then the catalogs is the way to do it.

Basically, the following is the approach used:

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]