remove a default constraint from table sql server code example
Example: sql server drop constraint default value
ALTER TABLE [TheTable] DROP CONSTRAINT [TheDefaultConstraint]
ALTER TABLE [TheTable] DROP CONSTRAINT [TheDefaultConstraint]