In this programming tutorial we will learn how to rename stored procedure in ms sql server. Its quite easy and a one line command to execute. So let's have a look over the command given below
Rename stored procedure in ms sql serverSyntax:
sp_rename 'procedure_name1', 'procedure_name2'
procedure_name1 is the current name of the stored procedure whereas procedure_name2 is the new name of the stored procedure.
A stored procedure can be renamed. The new name should follow the rules for identifiers.
EXEC sp_rename 'spCurrentName', 'spNewName';
So that's it. Stored Procedure has been renamed successfully.
I hope you will find this tutorial very informative. I love your feedback.