use EnVisage if not exists (select 1 from sys.all_columns where name like 'IsTemplate' and object_id = OBJECT_ID('Project')) begin alter table Project add IsTemplate bit CONSTRAINT templatedefault DEFAULT(0) NOT NULL alter table Project drop CONSTRAINT templatedefault end