我正在重构一个旧数据库,并删除不再使用的列. DB用于全文索引,所以有些列被标记为全文. 如何删除它们? 笔记: DB是MS SQL Server Express 2008 不再安装全文搜索服务 编辑: 我努力了 ALT
DB用于全文索引,所以有些列被标记为全文.
如何删除它们?
笔记:
> DB是MS SQL Server Express 2008
>不再安装全文搜索服务
编辑:
我努力了
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