I want to delete all procedures from my MySQL database sbnmaster
. How should I write a query for this?
Try this
USE sbnmaster;
SELECT CONCAT("DROP PROCEDURE IF EXISTS ",SPECIFIC_NAME) AS StorePrecedure
FROM information_schema.ROUTINES R
WHERE R.ROUTINE_TYPE = "PROCEDURE"
AND R.ROUTINE_SCHEMA = DATABASE();