SQL SERVER - Alter with Default Values
SQL SERVER - Alter with Default Values
-- Alter Table to add Field with Default Value for Existing Records
-- Which is not possible with Multiple Alter add Statement for Column and Constrainst
Alter TABLE [dbo].[Table_1] ADD [UUUX] [bit] NOT NULL CONSTRAINT [DF_Table_1_UUUX] DEFAULT 0
Alter TABLE [dbo].[Table_1] ADD [YUYUY1234] [int] NOT NULL CONSTRAINT [YUYUY1234] DEFAULT ((0))
Comments
Post a Comment