How to Remove All Stored Procedures in a Specific Database

[Ken Grigsby]

In MySQL 8 the database table `mysql`.`proc` does not exist. Previously I used this table to delete/remove/clear all stored procedures and recreate them from the source versioned code. This works very well to make sure development stored procedures where saved to source versioning before going to production.

Previously this SQL query worked.
DELETE FROM `mysql`.`proc` WHERE `type` = 'PROCEDURE' AND `db` = 'test';

1) Was the functionality to remove all stored procedures from a specific database in one statement removed from MySQL 8?
2) Is there an alternate way to achieve the results of the query in one statement?