>>IF NOT EXISTS(SELECT column_name >> FROM information_schema.columns >> WHERE table_name = N'AdultInfo' and column_name = N'MaritalStatus') >> BEGIN >> sp_executesql N'alter table AdultInfo add MaritalStatus char(1) null' -- Only to be in other batch >> ALTER TABLE [dbo].[AdultInfo] WITH CHECK ADD CONSTRAINT [CK_AdultInfo] CHECK (([MaritalStatus] IS NULL OR ([MaritalStatus] IN ('W','S','D','M')))) >> END >>>