How to rename a column in SQL Server

To rename a database table column use this code:

USE Database_name;
GO
sp_rename 'Table_name.[Old_Column_Name]', '[New_Column_Name]', 'COLUMN';
GO