[SQL Server]Rename a Column Name or Table Name

Introduction

Renaming any column
SP_RENAME ‘TableName.[OldColumnName]‘ , ‘[NewColumnName]‘, ‘COLUMN’

Renaming any object (table, sp etc)
SP_RENAME ‘[OldTableName]‘ , ‘[NewTableName]‘

Application
1.Renaming database table column to new name.

   sp_RENAME ‘Table_First.Name’, ‘NameChange’ , ‘COLUMN’

2.Renaming database table to new name.

   SP_RENAME ‘Table_First’, ‘Table_Last’