there are two possibilities, add new column with default value and ALLOW NULLs or NOT ALLOW NULLS. more details in this blog post https://info-spot.net/add-column-with-default-value-sql-server/