Database Reference
In-Depth Information
Figure 6-8.
Renaming a stored procedure
How It Works
The statement
sp_rename
is a predefined SQL Server stored procedure that accepts an object's old name
and the object's new name as parameters.
sp_rename 'sp_Select_All_PersonContact,
'sp_Select_All_ContactDetails'
Note
sp_rename
works very well with most of the objects when you want to rename them, such as tables,
columns, and other objects.
