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
Related posts:
How to clean Query and Execution Plan Cache for Efficient Testing in MS SQL
How to add default value for Entity Framework migrations for DateTime and Bool
How to find records based on CAPITAL and small letters in SQL Query?
Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql st...