I'm refactoring an old database and removing columns no longer in use. The DB used to have full text indexing, so, some column are marked for full text.
How can I remove them?
Notes:
Edit:
I have tried
ALTER FULLTEXT INDEX ON tableName DROP (ColumnName)
But gets this error:
Full-text crawl manager has not been initialized. Any crawl started before
the crawl manager was fully initialized will need to be restarted. Please
restart SQL Server and retry the command. You should also check the error
log to fix any failures that might have caused the crawl manager to fail.
To enable or disable a table for full-text indexing. Expand the server group, expand Databases, and expand the database that contains the table you want to enable for full-text indexing. Expand Tables, and right-click the table that you want to disable or re-enable for full-text indexing.
If “Full-Text Indexing” is greyed out it means that full-text indexing is not enabled.
Found the solution myself:
-- You should call the DISABLE command
ALTER FULLTEXT INDEX ON TableName DISABLE
ALTER FULLTEXT INDEX ON TableName DROP (ColumnName)
ALTER TABLE TableName DROP COLUMN ColumnName
I know this is an old post,I got stuck up,where i had to alter a column in table rather than drop.below code worked for me...
EXEC sp_fulltext_column //Drop your column from full text search here
@tabname = '<table_name>' ,
@colname = '<column_name>' ,
@action = 'drop'
ALTER TABLE ... //Alter your column here
EXEC sp_fulltext_column //Add your column back to full text search
@tabname = '<table_name>' ,
@colname = '<column_name>' ,
@action = 'add'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With