Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Statements : DROP PROCEDURE
 

DROP PROCEDURE

Deletes a stored procedure.
You can use the DROP PROCEDURE statement as an online and offline operation. For databases enabled for OpenEdge Replication the DROP PROCEDURE statement is an offline operation. For databases without OpenEdge Replication the DROP PROCEDURE statement is an online operation.

Syntax

DROP PROCEDURE [owner_name.]procedure_name ;

Parameters

owner_name
Specifies the owner of the procedure.
procedure_name
Name of the stored procedure to delete.

Example

The following example illustrates the DROP PROCEDURE statement:
DROP PROCEDURE new_sal ;
* Authorization
* Related statement