IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Kala' AND  COLUMN_NAME = 'CodeVahedMotevaset')
begin
	print 'Ok'
end
else
begin
	alter table Kala
	add	CodeVahedMotevaset	int foreign key references Vahed(code)
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Kala' AND  COLUMN_NAME = 'TedadVahedMotevaset')
begin
	print 'Ok'
end
else
begin
	alter table Kala
	add	TedadVahedMotevaset	float
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Kala' AND  COLUMN_NAME = 'CodeVahedBozorg')
begin
	print 'Ok'
end
else
begin
	alter table Kala
	add	CodeVahedBozorg		int foreign key references Vahed(code)
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Kala' AND  COLUMN_NAME = 'TedadVahedBozorg')
begin
	print 'Ok'
end
else
begin
	alter table Kala
	add	TedadVahedBozorg	float
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BargehDetail' AND  COLUMN_NAME = 'TedadVahedMotevaset')
begin
	print 'Ok'
end
else
begin
	alter table BargehDetail
	add	TedadVahedMotevaset	float
end
go
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BargehDetail' AND  COLUMN_NAME = 'TedadVahedBozorg')
begin
	print 'Ok'
end
else
begin
	alter table BargehDetail
	add	TedadVahedBozorg	float
end