Use drop procedure to remove stored procedures. Its syntax is:
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.
A procedure group, that is, more than one procedure with the same name but with different numbered suffixes, can be dropped with a single drop procedure statement. Once procedures have been grouped, procedures within the group cannot be dropped individually.
