Get All Stored Procedures names from SQL Server Database

In this article, I will explain how to get all stored procedure names from SQL Server Database. The below mentioned query will list all the stored procedures (Routines) available in the database.

select Routine_Catalog, Routine_Schema, Routine_Name, Routine_Type 
  from information_schema.routines 
 where routine_type = 'PROCEDURE' order by Routine_Name

In the above sample, Routine_Catalog is the Database Name, Routine_Name is the procedure name.

The mentioned below is the output for the above query.

Get All Stored Procedures names from SQL Server Database