Home Forums SQL Server 7,2000 T-SQL Change DEFAULT value for a column RE: Change DEFAULT value for a column

  • December 18, 2011 at 7:00 pm

    #1422939

    For SQL Sever 2008 do the following-

    ALTER TABLE dbo.bat_Batches DROP CONSTRAINT DF_bat_Batches_Version

    ALTER TABLE dbo.bat_Batches ADD CONSTRAINT DF_bat_Batches_Version DEFAULT ((2)) FOR bat_Batches_Version