IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Bargeh' AND COLUMN_NAME = 'CodeFarayandMoshtari') begin print 'Ok' end else begin alter table Bargeh add CodeFarayandMoshtari int foreign key references Farayand(code) end