How to rename a stored procedure in SQL Server?

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