Programming in MS SQL Server 2012

DELETE Stored Procedure



In SQL Server Enterprise Manager Application, locate the (EBusiness) database and expand the node, click the user-defined Stored Procedures node in the left pane and in the right pane, right-click (usp_EmployeeList) name of the stored procedure and then click Delete Stored Procedure option. Before delete an existing stored procedure, click Show Dependencies and then click Drop All option.

Query Output Screen



Note:

sp_help is used to displays user-defined stored procedure information.

sp_helptext is used to displays user-defined stored procedure source code.

* * * * *


Email Your Comment To AUTHOR