Step 1
To drop a stored procedure, switch to the correct database that holds your stored procedure.
Step 2
Inside MSSQL Query Analyzer type the following command
DROP PROCEDURE
Let’s say that we’re dropping a procedure called DemoStoredProcedure.
DROP PROCEDURE DemoStoredProcedure
As shown in the diagram below :
No comments:
Post a Comment