SQL in a Nutshell

Name

DROP PROCEDURE

Synopsis

This command destroys an existing stored procedure in the current user database.

Vendor	Command
SQL Server	Supported
MySQL	Not supported
Oracle	Supported
PostgreSQL	Not supported

SQL99 Syntax and Description

DROP PROCEDURE procedure_name {RESTRICT | CASCADE}

This command is essentially the same as DROP FUNCTION, except that it acts upon stored procedures rather than functions.

Microsoft SQL Server Syntax and Variations

DROP PROCEDURE [owner_name.]procedure_name [,...n]

Microsoft SQL Server allows the removal of multiple stored procedures by placing a comma between the name of each one. Individual versions of stored procedures cannot be dropped. The entire group of stored-procedure versions must be dropped.

Oracle Syntax and Variations

DROP PROCEDURE [owner_name.]procedure_name

Oracle also allows any procedure to be dropped based on the owner name. Users with the system privilege, DROP ANY PROCEDURE, may drop procedures owned by other users.