Rename stored procedure in ms sql server

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 server

Syntax:
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.

0 comments: