Drop Column Error 1

[jmcg]

I am trying to drop a column in my SQL Server 2005 database and getting an error.
The code I am running is:

ALTER TABLE Targets DROP COLUMN Connections

and I am getting the error:

The object 'DF___Targets_Conne___25A75D29' is dependant on column 'Connections'

Any suggestions to what may be the problem?

 

[bborissov]

You have set default value for this column and SQL Server generate a strange name for the constraint .
You should drop this constraint before you drop the column.

ALTER TABLE Targets 
       DROP CONSTRAINT DF___Targets_Conne___25A75D29
GO
ALTER TABLE Targets DROP COLUMN Connections

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[jmcg]

Borislav
Thanks this works.

Does this means that if I remove the default values for the field then I will not need the DROP CONSTRAINT element?

 

[bborissov]

Sure,
SQL Serer will remove that constraints for you when you press save button.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[jmcg]

Excellent