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.
DROP PROCEDURE dbo.uspMyProc; GO
"The best way to get a bad law repealed is to enforce it strictly" - Abraham Lincoln
sys.sql_modules - view procedure definition
Equivalent Oracle command: DROP PROCEDURE