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 ;