IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'gardesheChek' AND COLUMN_NAME = 'CodeHazineh') begin print 'Ok' end else begin alter table gardesheChek add CodeHazineh bigint foreign key references tafsili(Code) end go IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'gardesheChek' AND COLUMN_NAME = 'Mablagh') begin print 'Ok' end else begin alter table gardesheChek add Mablagh decimal(19,4) end