IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Places' AND COLUMN_NAME = 'MaxFormCount') begin alter table Places add MaxFormCount int null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Places' AND COLUMN_NAME = 'Place_ID_Web') begin alter table Places add Place_ID_Web int references Places(ID) null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Places' AND COLUMN_NAME = 'IconFont') begin alter table Places add IconFont nvarchar(100) null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Places' AND COLUMN_NAME = 'IconColor') begin alter table Places add IconColor nvarchar(100) null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Places' AND COLUMN_NAME = 'Url') begin alter table Places add Url nvarchar(1000) null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Places' AND COLUMN_NAME = 'Dom_ID_IsActive_Web') begin alter table Places add Dom_ID_IsActive_Web int references Domain(ID) null end