Alter/Change new Default Value of a Column in already created Table

  

ALTER TABLE {table-name} DROP CONSTRAINT {column-constraint-name}

ALTER TABLE {table-name} WITH NOCHECK 
ADD CONSTRAINT [{column-constraint-name}] DEFAULT (6) FOR {column-name}