table help

• SQLRep

  SSCrazy

  Points: 2052

  More actions

  November 16, 2005 at 11:56 am

  #166221

  How can i alter this Test table for the column to default value 0 instead NULL.

  here is the table

  Test

  cusid folat  Null  --> need to change this to default 0

  amount real  NULL  --> need to change this to default 0

  Thanks

• CTracy

  SSC Eights!

  Points: 903

  More actions

  November 16, 2005 at 1:45 pm

  #604288

  ALTER TABLE [dbo].[Test]

  ADD CONSTRAINT [DF_dbo_Test_amount] DEFAULT 0 FOR [amount]

• Sameer Raval

  Hall of Fame

  Points: 3214

  More actions

  November 17, 2005 at 1:26 pm

  #604518

  Here you need to take note of one additional Information.

  If table is populated with Rows then

  Add Constraint is not going to change the null data

  values from the previously populated rows.

   

   

   

   

   

  Kindest Regards,

  Sameer Raval [Sql Server DBA]
  Geico Insurance
  RavalSameer@hotmail.com