IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'bargehDetail' AND COLUMN_NAME = 'CodeTakhfif') begin print 'Ok' end else begin alter table bargehDetail add CodeTakhfif bigint foreign key references tafsili(code) end