Wednesday, March 11th, 2009 by Niall Add Default Value To Existing MS SQL Column I can never get this syntax to stick in my head. ALTER TABLE someTable ADD CONSTRAINT DF_someTable_someColumn DEFAULT getdate() FOR someColumn Share this:TwitterFacebookLike this:Like Loading... Related