Getting All Stored Procedures Inside a Database
July 25, 2016
11:07 pm
There are essentially two ways to get a list of all Stored Procedures inside your database. Option 1: SELECT *FROM YOUR_DATABASE_NAME.information_schema.routinesWHERE routine_type = ‘PROCEDURE’ORDER BY Specific_name This option checks the database’s objects itself for a Procedure type. This produces a list of all procedure routines in your database. Option 2:
