IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'bargeh' AND  COLUMN_NAME = 'Bar_ID')
begin
alter table bargeh Add Bar_ID int references Bargeh(ID) null
end
go
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BargehDetail' AND  COLUMN_NAME = 'BD_ID')
begin
alter table bargehDetail Add BD_ID int references bargehDetail(ID) null
end
go