Alter Default on a Column
Does anyone know if it is possible, via the ordinary ALTER TABLE, to change an existing DEFAULT on a varchar column? I know that it is possible through EM, but I need to do it in a script. I've tried the syntax from BOL, but keeps getting SYNTAX ERROR.
Could someone please help me with an example?
Thank you in advance.