Custom Search
Logiclabz
  • Home
  • Sql Server
  • Alter/Change new Default Value of a Column in already created Table

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}



  


Leave a reply




Do you like this post?