>>>IF NOT EXISTS >>>(SELECT column_name >>>FROM INFORMATION_SCHEMA.COLUMNS >>>WHERE TABLE_NAME = N'Volunteers' and COLUMN_NAME = N'IsActive') >>>BEGIN >>> SET @SQLString = N'alter table Volunteers add IsActive bit null CONSTRAINT [DF_Volunteers_IsActive] DEFAULT ((1))' >>> EXECUTE sp_executesql @SQLString -- Only to be in other batch >>> UPDATE Volunteers SET IsActive = 1 >>>END>>>
IF NOT EXISTS(SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'Volunteers' and COLUMN_NAME = N'IsActive') BEGIN alter table Volunteers add IsActive bit NOT NULL CONSTRAINT [DF_Volunteers_IsActive] DEFAULT (1) END