There are many ways where in we can rename a column but what I prefer is using predefined stored Procedure sp_rename .
exec sp_rename ‘tablename.ColumnName’, ‘NewColumnName’, ‘column’ –objecttype
EX: changing the column name “Name” to “FirstName”
create table Personal(ID int, Name varchar(50))
EXEC sp_rename ‘Personal.Name’, ‘FirstName’, ‘column’
The message displayed is a caution message that says when we alter the column name there is a possibility that it can be used in one or more stored procedures so make sure you update everything and then only change the name .
Reference : Dilip Kumar Jena ( https://sqlexplore.wordpress.com )