Dropping Stored Procedures

The DROP PROCEDURE statement removes stored procedures from the current database.

If a stored procedure that has been dropped is called by another stored procedure, SQL Server displays an error message. However, if a new procedure of the same name is defined to replace the one that was dropped, other procedures that reference it can call it successfully.

A procedure group (more than one procedure with the same name but different ;number suffixes) can be dropped with a single DROP PROCEDURE statement. Once procedures have been grouped, procedures within the group cannot be dropped individually.

    To drop a stored procedure

• In SQL Enterprise Manager's Server Manager window, select the stored procedure you want to drop, click the right mouse button, and then choose Drop.

  (For details, search for stored procedures in SQL Enterprise Manager Help.)

Or

• Use the DROP PROCEDURE statement.

  For example:

  DROP PROCEDURE mary_proc

  drops the mary_proc procedure from the preceding section.

  (For details, see the DROP PROCEDURE statement in the Microsoft SQL Server Transact-SQL Reference.)