How to rename a column name or table name in sql

1. You can rename column name as below:
sp_Rename 'tblusers.Name' , 'UserName', 'column'

2. Using below sql statement you can change object name ( table name, stored procedure name..etc)
sp_Rename 'tblusers', 'tblGlobalUsers'