IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND COLUMN_NAME = 'Far_ID_BedehKar') begin ALTER TABLE ProductDetail add Far_ID_BedehKar int references Farayand(Code) null end IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND COLUMN_NAME = 'Taf_ID_BedehKar') begin ALTER TABLE ProductDetail add Taf_ID_BedehKar bigint references Tafsili(Code) null end