>>What Antonio suggested works. Except when I use the default.
>>
>>Example:
>>
>>ALTER TABLE MyTable ALTER COLUMN notes varchar(max) not null default ''
>>
>>
>>I am getting error "near key word Default"
>>
>>What am I missing?
>>
>>TIA
>
>Dmitry, I think this is how MSSQL adds a default value to an existing column:
>
>
>ALTER TABLE MyTable ADD CONSTRAINT DF_NotesAreEmpty DEFAULT '' FOR notes;
>
Antonio,
I am sure your code works. But what I found is that if I change the type from Text to Varchar(max) and simply add NOT NULL, the default of the Text type stays. So, in the end I don't need to set the default.
Thank you.
UPDATE. I believe you are right. I have to "deal" with the constraint. Because when I ALTER the column, the SQL complaints that the field NOTES depends on the constraint. So, I will have to drop the constraint first.
It is never very simple :)
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham