IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'productFormulDetail' AND  COLUMN_NAME = 'Pro_ID')
begin
	print 'Ok'
end
else
begin
	alter table productFormulDetail add Pro_ID int references OtherProperties (ID) not null default -1
end

IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'productFormulDetail' AND  COLUMN_NAME = 'Far_ID')
begin
	print 'Ok'
end
else
begin
	alter table productFormulDetail add Far_ID int references Farayand (Code)
end

IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'productFormulDetail' AND  COLUMN_NAME = 'Taf_ID_Bestankar')
begin
	print 'Ok'
end
else
begin
	alter table productFormulDetail add Taf_ID_Bestankar bigint references Tafsili (Code)
end