ALTER TABLE AND DEFAULT

• randyt

  SSC Veteran

  Points: 202

  More actions

  August 19, 2002 at 10:12 am

  #78852

  hi,

  I'm trying to change the default value of a group of columns. I've tried

  ALTER TABLE users ALTER COLUMN picker varchar(20) DEFAULT '1'

  but this returns problem near default any idea on how to set default values for a group of columns?

  thanks

  Randy

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  August 19, 2002 at 12:44 pm

  #434802

  Since the column already exists, you'll need to add it as a constraint:

  
  
  ALTER TABLE users
  
  ADD CONSTRAINT DF_users_picker DEFAULT '1' FOR picker
  
  

  K. Brian Kelley

  http://www.truthsolutions.com/

  Author: Start to Finish Guide to SQL Server Performance Monitoring

  http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

  K. Brian Kelley
  @kbriankelley