I need to change the collation on a field (well actually a couple of fields). And this is for a program which we have widely distributed.

So essentially, programicably,

1. I delete all of the indexes if a segment contains a field that I am editting
2. I use embedded sql to alter the table
3. I recreate the indexes

Piece of cake, right? Well not so fast. Because when I issue this command:
Code:
ALTER TABLE dbo.ARCUST
ALTER COLUMN [SHIP_ADD1]
text COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL;
I get an error:
Msg 5074, Level 16, State 1, Line 1The object 'DF__ARCUST__SHIP_ADD__3A179ED3' is dependent on column 'SHIP_ADD1'.
Msg 4922, Level 16, State 9, Line 1
ALTER TABLE ALTER COLUMN SHIP_ADD1 failed because one or more objects access this column.

And then that's when I realized the I have to delete the SQL Contraints as well. Now I can manually delete them in the SSMS, but again I need to do it programicably. Problem is, I haven't found a way to find the name of the Constraints programicably.

Any thoughts, ideas, solutions?

TIA
Mike