# How to change the DEFAULT value for a column

04-12-2014

###First, drop the existing default constraint if necessary If the column already has a default value, we can get the existing default constraint name from the Table Designer or DDL.

And then we need to drop the constraint using the command shown below:

ALTER TABLE dbo.YouTableName DROP CONSTRAINT TheExistingConstrainName;


ALTER TABLE dbo.YouTableName ADD CONSTRAINT YourNewConstraintName

Alternatively, you can reuse the TheExistingConstraintName instead of YourNewConstrainName