SQL Server - How to rename a column or table

With T-Sql we have a very convenient store to rename the name of a column or a table, sp_rename

To rename an object (table, store procedure, etc.):
SP_RENAME '[OldTableName]' , '[NewTableName]'

To rename a column:
SP_RENAME ‘TableName.[OldColumnName]' , ‘[NewColumnName]', 'COLUMN'