IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BargehDetail' AND COLUMN_NAME = 'AverageUnitValue') begin alter table BargehDetail add AverageUnitValue float null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BargehDetail' AND COLUMN_NAME = 'LargeUnitValue') begin alter table BargehDetail add LargeUnitValue float null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BargehDetail' AND COLUMN_NAME = 'Pro_ID_UnitAverage') begin alter table BargehDetail add Pro_ID_UnitAverage int references OtherProperties(ID) null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BargehDetail' AND COLUMN_NAME = 'Pro_ID_UnitLarge') begin alter table BargehDetail add Pro_ID_UnitLarge int references OtherProperties(ID) null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaDarAnbar' AND COLUMN_NAME = 'AverageUnitValue') begin alter table KalaDarAnbar add AverageUnitValue float null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaDarAnbar' AND COLUMN_NAME = 'LargeUnitValue') begin alter table KalaDarAnbar add LargeUnitValue float null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaDarAnbar' AND COLUMN_NAME = 'TedadVahedMotevaset') begin alter table KalaDarAnbar add TedadVahedMotevaset float null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaDarAnbar' AND COLUMN_NAME = 'TedadVahedBozorg') begin alter table KalaDarAnbar add TedadVahedBozorg float null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaDarAnbar' AND COLUMN_NAME = 'Pro_ID_UnitAverage') begin alter table KalaDarAnbar add Pro_ID_UnitAverage int references OtherProperties(ID) null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaDarAnbar' AND COLUMN_NAME = 'Pro_ID_UnitLarge') begin alter table KalaDarAnbar add Pro_ID_UnitLarge int references OtherProperties(ID) null end