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 |