错误:无法更改或删除列“x”,因为它已启用全文搜索

2024-01-10

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

我怎样才能删除它们?

Notes:

  • 数据库是 MS SQL Server Express 2008
  • 不再安装全文搜索服务

Edit:
我努力了

ALTER FULLTEXT INDEX ON tableName  DROP (ColumnName)

但出现此错误:

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.

自己找到了解决方案:

-- 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
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

错误:无法更改或删除列“x”,因为它已启用全文搜索 的相关文章

随机推荐