How to get a list of all storedprocedures in a Database

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

Please Share us:
Please rate this snippet

One thought on “How to get a list of all storedprocedures in a Database

Leave a Reply