mysql Stored Procedure The following sql list the name of all the routines in a given database.

SELECT ROUTINE_NAME

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_TYPE="PROCEDURE" AND ROUTINE_SCHEMA="dbname";