DROP PROCEDURE

Drop one or more stored procedures (or procedure groups) from the current database.

Syntax
      DROP PROCEDURE [schema.]procedure [,...n ];

Key
   procedure     The stored procedure or stored procedure group to be removed.

This command can also be shortened to DROP PROC... 

This command requires that the partition scheme is not currently being used by any tables or indexes.

Example

DROP PROCEDURE dbo.uspMyProc;
GO

"The best way to get a bad law repealed is to enforce it strictly" - Abraham Lincoln

Related commands:

CREATE PROCEDURE
ALTER PROCEDURE
sys.sql_modules - view procedure definition

Equivalent Oracle command:

DROP PROCEDURE