I'm trying to create a script to clean up some columns between two revisions, and I'm having trouble with one that is full-text enabled:

ALTER TABLE tblNote DROP COLUMN colComments

I get the message:

Cannot alter or drop column 'colComments' because it is enabled for Full-Text Search.

I can't seem to find a way to remove the full-text index using scripting.

Any suggestions would be appreciated.

Geoff.