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
To get a list of all storedprocedures in a Database you can use te following snippet.
select * from Testdatabase.information_schema.routines where routine_type = 'PROCEDURE' ORDER BY ROUTINE_NAME ASC