IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND COLUMN_NAME = 'CodeKolSanadPardakhti') begin print 'Ok' end else begin alter table Tafsili add CodeKolSanadPardakhti bigint foreign key references Kol(code) end go IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND COLUMN_NAME = 'CodeMoinSanadPardakhti') begin print 'Ok' end else begin alter table Tafsili add CodeMoinSanadPardakhti bigint foreign key references Moin(code) end