|
|
|
DROP PROCEDURE
Description
Deletes a stored procedure.
Syntax
DROP PROCEDURE [IF EXISTS] [ owner_name. ] procedure_name ;
Arguments
IF EXISTS
This argument avoids failure by attempting to drop the procedure only if a procedure of that name already exists.
owner_name
Specifies the owner of the procedure.
procedure_name
Names of the stored procedure to delete.
Example
DROP PROCEDURE new_sal ;
Authorization
To drop a stored procedure, users must be the owner of the procedure or have the DBA privilege.
SQL Compliance |
SQL-93, ODBC Core SQL grammar |
Environment |
Embedded SQL, interactive SQL, ODBC applications |
Related Statements |
CALL, CREATE PROCEDURE |
