Retrieve List of all Stored Procedures in SQL Server

The following queries will return a list of all Stored Procedures in the database, with basic information about each Stored Procedure:

We can achieve this by various methods.

Method 1:

USE AdventureWorks2017
GO
SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE'

The ROUTINE_NAME, ROUTINE_SCHEMA and ROUTINE_DEFINITION columns are generally the most useful

Output:

Below both the methods will yield same result.

Method 2:

SELECT *
FROM sys.objects
WHERE type = 'P'

Method 3:

SELECT *
FROM sys.procedures

Output:

Related Article:

• Retrieve information on backup and restore operations in SQL Server
• Return list of SQL Agent jobs with schedule information in SQL Server
• Count the Number of Tables in a Database in SQL Server
• Retrieve List of all Stored Procedures in SQL Server
• Display all data files for all databases with size and growth info in SQL Server
• Get all schemas, tables, columns and indexes in SQL Server
• Retrieve all Table detail from Known Column in SQL Server
• Get the list of all databases on a server in SQL Server
• Show Size of All Tables in Current Database in SQL Server