错误：由于已启用全文搜索，因此无法更改或删除列'x' [英] Error: Cannot alter or drop column 'x' because it is enabled for Full-Text Search

问题描述

我正在重构旧的数据库并删除不再使用的列。
数据库曾经有全文索引，所以有些列被标记为全文。

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.

我可以如何移除它们？

注意：

• DB是MS SQL Server Express 2008


• 不再安装全文搜索服务
  

• DB is MS SQL Server Express 2008
• Full text search service is no longer installed

编辑：

我曾尝试

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.

推荐答案

我自己找到解决方案：

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

这篇关于错误：由于已启用全文搜索，因此无法更改或删除列'x'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！