Answers for "drop default value constraint in sql server and reecreate it"

sql server drop constraint default value

ALTER TABLE [TheTable] DROP CONSTRAINT [TheDefaultConstraint]

sql drop default

Removes a default value for a column.
Example (MySQL): Removes the default value from the ‘name’ column in
the ‘products’ table.
ALTER TABLE products
ALTER COLUMN name DROP DEFAULT;