Hi,

I had this thread in VFP forum and I thought I was all set but I ran into a Catch 22 problem.

I want to write a script for the SSMS to change a column from Text to Varchar(max) keeping default as empty string ('').
The column currently has a Default Constraint (e.g. DF_mytable_mycolumn). I tried to delete this constraint but I get a message

"The default "df_mytable_mycolumn" does not exist on the server"

I presume that this message is because this constraint is being used.
At the same time if I write a script to Alter the column (mycolumn) to varchar(max), I get error that

"The object 'DF_mytable_mycolumn' is dependent on column 'mycolumn'.

So, how do I drop the default constraint then? Or how do I incorporate everything in the Alter column statement?

TIA