IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BargehDetail' AND COLUMN_NAME = 'Pro_ID_Unit') begin alter table BargehDetail add Pro_ID_Unit int references otherProperties(ID) not null default -1 end ; update b set b.Pro_ID_Unit = k.Pro_ID_Vahed from kala k inner join BargehDetail b on k.ID = b.Kal_ID where b.Pro_ID_Unit = -1