DROP PROCEDURE

Description

Deletes a stored procedure.

Syntax

DROP PROCEDURE [ owner_name. ] procedure_name ;

Arguments

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