Rename stored procedure in SQLServer

Renaming stored procedure is done often by the developers.The below is the stored procedure:

Syntax:

sp_rename 'old stored procedure','new stored procedure'


Example:

EXEC sp_rename 'spGetEmpDetails', 'spGetEmployeeDetails';