Getting All Stored Procedures Inside a Database

Getting All Stored Procedures Inside a Database

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:

SELECT name,typeFROM dbo.sysobjectsWHERE (type = 'P') 

This simply does a search through the dbo object where it is a procedure.


About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist