How to rename database table column with new name?

Using Management Studio, right-click the tablename, select Design from the pop-up menu, click the column you want to rename, type the desired column name then click save.

You can use sp_rename like this:

exec sp_rename 'tableName.OlColName', 'new column name', 'COLUMN'