How to Rename a Column Name or Table Name using SQL Script In MS-SQL?

SP_RANAME:is a system function is used to rename column or any database objects (table or view or storedprocedure or function) 
The script for renaming any column or index or datatype:
EXECUTE SP_Rename ‘Tablename.colname’, ‘Newcolname’,’COLUMN’
The script for renaming any object (table, view, usp etc):
EXECUTE SP_Rename ‘Tablename’ , ‘New_name’
The above two examples of renaming database object.
·        Renaming database table column to new name.
·        Renaming database table to new name.
In both the cases we will first see existing table. Rename the object. Test object again with new name.
Syntax
sp_rename ‘object_name’ ,’new_name’,’object_type’
Permissions
To rename objects, columns, and indexes, requires ALTER permission on the object. To rename user types, requires CONTROL permission on the type. To rename a database, requires membership in the sysadmin or dbcreator fixed server roles.