Deleting an existing procedure
To delete an existing procedure, select 
in the “Procedures” management dialog box. Note that confirmation is necessary for the prompt dialog box:
Available in: Standard, Professional and Enterprise Editions.