Alter Table Add Field with Constraint

Alter Table Add Field with Constraint.sql

if not exists (select 1 from syscolumns where name = 'Integrated_Mapping' and ID in (select so.ID from sysobjects so where so.name = 'PRODUCTS' and so.type = 'U') )
  alter table PRODUCTS ADD Integrated_Mapping bit NULL
GO	


UPDATE PRODUCTS SET Integrated_Mapping = 0 where (Integrated_Mapping IS NULL)
GO
	
if not exists ( select 1 from sysconstraints where constid in 
			(select so.ID from sysobjects so 
			 where so.name = 'df_Product_IntgMapping' and so.type = 'D')
		  )
	ALTER TABLE [dbo].[PRODUCTS] ADD  CONSTRAINT [df_Product_IntgMapping]  DEFAULT ((0)) FOR [Integrated_Mapping]
GO