IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaProperty' AND COLUMN_NAME = 'Price') begin alter table KalaProperty add Price decimal(19,4) null end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaProperty' AND COLUMN_NAME = 'Tarikh') begin alter table KalaProperty add Tarikh int null end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaProperty' AND COLUMN_NAME = 'Percent') begin alter table KalaProperty add [Percent] float null end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaProperty' AND COLUMN_NAME = 'Mat_ID') begin alter table KalaProperty add Mat_ID bigint references Matter(ID) null end;