How to change a column name in sql server using t-sql.

here is the way to change a column name in t sql
EXEC sp_rename @objname = 'tablename.oldcolumnName', @newname = 'newcolumnName',@objtype = 'COLUMN'

reference : http://msdn2.microsoft.com/en-us/library/ms188351.aspx