IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Bargeh' AND COLUMN_NAME = 'FarayandeHazineVisitor') begin exec sp_RENAME 'Bargeh.FarayandeHazineVisitor', 'temp' , 'COLUMN' end else begin print 'Ok' end go IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Bargeh' AND COLUMN_NAME = 'CodeFarayandVisitor') begin exec sp_RENAME 'Bargeh.CodeFarayandVisitor', 'HazineVisitor' , 'COLUMN' end else begin print 'Ok' end go IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Bargeh' AND COLUMN_NAME = 'temp') begin exec sp_RENAME 'Bargeh.temp', 'CodeFarayandVizitor' , 'COLUMN' end else begin print 'Ok' end