If there is no default value for the column then you can use this query:
ALTER TABLE MyTable ADD CONSTRAINT df_MyTable_MyColumn DEFAULT 0 FOR MyColumn
But if there is a default value then first you must drop it:
ALTER TABLE MyTable DROP CONSTRAINT df_MyTable_MyColumn
