Use drop procedure to remove stored procedures:
drop proc[edure] [owner.]procedure_name [, [owner.]procedure_name] ...
If a stored procedure that was dropped is called by another stored procedure, Adaptive Server 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.
