从现有表sql中删除列时出错 [英] error while delete a column from existing table ,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屋！