What is the use of sp_rename in Sql Server?

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

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.

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