SqlServer: How to drop a column with a randomly named (default) constraint?

[Super Lloyd]

I created a table in SqlServer with CREATE TABLE Foo( column1 bit not null default 0, ..... ) this implicitly created a randomly named constraint which would set the default value. Now when I try to run ALTER TABLE Foo DROP COLUM column1 I got the error message DF_Foo_colum_2F34CDE is dependent on column1, i.e. the randomly named constraint which sets the default value prevent the deletion of the column. Now I could fix that on my database, but how could I write a script which will work on all databases?

A train station is where the train stops. A bus station is where the bus stops. On my desk, I have a work station.... _________________________________________________________ My programs never have bugs, they just develop random features.

[Super Lloyd]

I found out how to find those bastards! SELECT * FROM sys.sysobjects Where NAME LIKE 'DF__Foo%' or SELECT * FROM sys.objects type_desc='DEFAULT_CONSTRAINT' But I also had a better work around: :-D 1. these nameless constraints being only on developers machines so far, I just dropped them manually 2. and give them a name in the create table with CREATE TABLE FOO ( column1 bit not null CONSTRAINT DF_Foo_column1 DEFAULT 0 .... )

A train station is where the train stops. A bus station is where the bus stops. On my desk, I have a work station.... _________________________________________________________ My programs never have bugs, they just develop random features.