Using following ways by which you can rename a stored procedure in SQL Server
(1) Using SSMS 'SQL Server Management Studio'
Using object explorer navigate to database > Programability > Stored Procedures > Right click on SP you want to rename > click rename.
(2) Using 'sp_rename'
Using system procedure 'sp_rename' in the query window of SSMS
sp_rename 'oldname','newname'
No comments:
Post a Comment