Sql Server : Change Column & Table Name

Change Column Name :-
sp_RENAME 'TableName.OldColumnName', 'NewColumnName' , 'COLUMN'


Example:
'TableName.OldColumnName' Variables
'NewColumnName' Variables
'COLUMN' is Fixed value.


Change Table Name :-

sp_RENAME 'oldTableName, 'NewTableName'