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.