Dropping Stored Procedures

Use drop procedure to remove stored procedures.

The syntax is:
drop proc[edure] [owner.]procedure_name 
     [, [owner.]procedure_name] ... 

If a stored procedure that was dropped is called by another stored procedure, SAP ASE displays an error message. However, if a new procedure of the same name is defined to replace the one that was dropped, other procedures that reference the original procedure can call it successfully.

Once procedures have been grouped, procedures within the group cannot be dropped individually.