What is the use of sp_rename in Sql Server?

 Posted by vishalneeraj-24503 on 1/24/2014 | Category: Sql Server Interview questions | Views: 1805 | Points: 40

sp_rename is a system stored procedure which is basically used to rename any existing Stored Procedure.
We provide existing sp name and new sp name in sp_rename.

exec sp_rename 'proc1','proc2';

Where: proc1 is our existing procedure name which will be renamed.
and proc2 is our new procedure name.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response