Hi,

I want to add a DEFAULT constraint to an existing table/field. What is the syntax?

"alter table mytable alter column myfield int null" works great but ...
"alter table mytable alter column myfield int null default null" gives me an error?!?

So - how do I add the default?

Thanks,
Ken