To get a list of all storedprocedures in a Database you can use te following snippet.

Sample SQL

select * from Testdatabase.information_schema.routines where routine_type = 'PROCEDURE' ORDER BY ROUTINE_NAME ASC