default in table

• ravi

  SSC Veteran

  Points: 257

  More actions

  February 26, 2004 at 1:45 pm

  #84299

  Hi,

  how to give default value to a existing column in table.

  example.

  create table rr(s varchar(1) null)

  now i like to add default value to s column. i tried following.

   

  alter table rr alter column s varchar(1) default 'N'

  but it is giving syntax is wrong.

  thanx

   

   

   

• srankin

  Say Hey Kid

  Points: 703

  More actions

  February 26, 2004 at 1:57 pm

  #496003

  Lookup CREATE DEFAULT

  and sp_bindefault

• noeld

  SSC Guru

  Points: 96590

  More actions

  February 26, 2004 at 2:53 pm

  #496023

  Alter Table rr

  ADD CONSTRAINT DF_rr_s  DEFAULT 'N' FOR s

  
  * Noel

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 27, 2004 at 2:39 am

  #496118

  create table rr(s varchar(1) null)

  varchar(1) ???

  This is only an example, right? If not, you should change it to char.

  

   

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]