从现有表sql中删除列时出错 [英] error while delete a column from existing table ,sql
本文介绍了从现有表sql中删除列时出错的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的表名是Accgroups,当我开始用以下查询删除它时我想删除BranchID列它显示错误
ALTER TABLE AccGroups DROP COLUMN BranchID
消息5074,级别16,状态1,行1
对象'IX_AccGroups'依赖于列'BranchID'。
消息4922,级别16,状态9,行1
ALTER TABLE DROP COLUMN BranchID失败,因为一个或多个对象访问此列。
解决方案
试试这个代码
ALTER TABLE dbo.AccGroups DROP CONSTRAINT IX_AccGroups
ALTER TABLE dbo.AccGroups DROP COLUMN BranchID
我尝试这个代码....我成功了
ALTER TABLE dbo.AccGroups
DROP CONSTRAINT IX_AccGroups
EXECUTE sp_unbindefault N'dbo.AccGroups.IX_AccGroups'
ALTER TABLE dbo.AccGroups
DROP COLUMN BranchID
我感谢大家......
my table name is Accgroups in which i want to delete BranchID column when i start to delete it with below query it showing the error
ALTER TABLE AccGroups DROP COLUMN BranchID
"Msg 5074, Level 16, State 1, Line 1
The object 'IX_AccGroups' is dependent on column 'BranchID'.
Msg 4922, Level 16, State 9, Line 1
ALTER TABLE DROP COLUMN BranchID failed because one or more objects access this column.
"解决方案try this code
ALTER TABLE dbo.AccGroups DROP CONSTRAINT IX_AccGroups ALTER TABLE dbo.AccGroups DROP COLUMN BranchID
i tries this code ....i succeded
ALTER TABLE dbo.AccGroups
DROP CONSTRAINT IX_AccGroups
EXECUTE sp_unbindefault N'dbo.AccGroups.IX_AccGroups'
ALTER TABLE dbo.AccGroups
DROP COLUMN BranchID
I thank to everybody...
这篇关于从现有表sql中删除列时出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文