Get All Stored Procedure Name From a SQL Server Data Base

Here I am going to show how we can get a list of all stored procedure from a SQL Server Data Base using below Query:

SELECT [Routine_Name] , CREATED, LAST_ALTERED
FROM [INFORMATION_SCHEMA].[ROUTINES]
WHERE [ROUTINE_TYPE] = 'PROCEDURE'

 

Image 1.