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

  • December 7, 2005 at 9:21 am

    #608202

    Oh!  Got it now.  Thanks, ramses2nd!  Syntax is:

    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 Version;