I am a coding database upgrade program to alter table structure in SQL Server. Here's what I have to do:
1) Determine default constraint name for a given column
2) Drop the constraint
3) Drop the column

It appears that a constraint may be used by multiple columns. Is this true, and if so, how do I disassociate the column from the default constraint?

Also, to determine the constraint name am using sp_helpconstraint and
LOCATE "DEFAULT on column"+lcColumnName. Is there a better way?

Thanks
-Brett