error while delete a column from existing table ,sql

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

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.
"

Posted 3-Mar-14 17:41pm

Mohammed Shamsheer

Add a Solution

Comments

Amalraj Ramesh 3-Mar-14 23:45pm

Have refer this BranchID as foreign key reference

Amalraj Ramesh 3-Mar-14 23:49pm

In management studio right click on table name and click on view dependencies
It will show the dependencies tables and sp

Member 8622273 4-Mar-14 0:10am

in order to delete a column having dependencies, first you have to delete the constraint and then try to delete the column.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

george4986 · Accepted Answer · 2014-03-03T18:09:00

Solution 1

try this code

SQL

ALTER TABLE dbo.AccGroups DROP CONSTRAINT IX_AccGroups
ALTER TABLE dbo.AccGroups DROP COLUMN BranchID

Posted 3-Mar-14 18:09pm

george4986

Comments

Ankur^\m/ 4-Mar-14 0:15am

Note to OP: Just to give more detail - the error shows because there is a constraint named 'IX_AccGroups' on that column (probably an index) which is not allowing it to delete. You first need to drop that constraint and then you can delete the column.
5!

george4986 4-Mar-14 0:18am

sorry i did't explained my solution
thanks Ankur ;-) gud luck.

Mohammed Shamsheer · Accepted Answer · 2014-03-03T18:40:00

Solution 2

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...

Posted 3-Mar-14 18:40pm

Mohammed Shamsheer

v2