Drop a colum in MS SQl 2000

Richardwilliams · August 18th, 2005, 01:09 PM

Hi I am trying to drop a column which i created but i am getting this statement

Server: Msg 3728, Level 16, State 1, Line 1
'MemberAtended' is not a constraint.
Server: Msg 3727, Level 16, State 1, Line 1
Could not drop constraint. See previous errors.

Can you help

SqlMenace · October 21st, 2005, 03:05 PM

Can you show the SQL statement

âI sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/

seananderson · November 23rd, 2006, 06:30 AM

I have the same problem:

ALTER TABLE TEST2 DROP NEWFIELD1

Server: Msg 3728, Level 16, State 1, Line 1
'NEWFIELD1' is not a constraint.
Server: Msg 3727, Level 16, State 1, Line 1
Could not drop constraint. See previous errors.

Regards,

Sean Anderson

vinod_yadav1919 · November 23rd, 2006, 07:37 AM

HII seananderson!!
Hope this will help you
http://www.w3schools.com/sql/sql_alter.asp
http://www.infogoal.com/sql/sql-alter-table.htm

Cheers :)

vinod