Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Change DEFAULT value for a column

    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

Viewing post 1 (of 1 total)