The script for renaming any column :
sp_RENAME 'TableName.[oldcolumnname]' , '[Newcolumnname]', 'COLUMN'
For example if my table name is class and having column fees and i want to change column name fees to NewFees then the script will be like
sp_RENAME 'dbo.class.fees', 'NewFees' , 'COLUMN'