Changing a fields default value

• Kim Fenstad

  Newbie

  Points: 1

  More actions

  May 24, 2004 at 11:00 am

  #160946

  Hello,

  Does anyone know if there is a way to change the default value of a field using T-SQL? 

  Thanks!

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  May 24, 2004 at 12:11 pm

  #507540

  Try

  ALTER TABLE <TABLENAME>

  DROP CONSTRAINT <CONSTRAINT NAME>

  GO

  ALTER TABLE <TABLENAME>

  ADD CONSTRAINT <CONSTRAINT NAME>

  DEFAULT <DEFAULT VALUE> FOR <COLUMN NAME>

  GO

  ---

  
  Shamless self promotion - read my blog http://sirsql.net