We get a procedure list with the help of DMV like " Sys.objects & sys.parameters"
USE [SqlBank]
SELECT s.NAME StoreProcedure, p.NAME Parameter FROM SYS.PARAMETERS p
JOIN SYS.OBJECTS s on p.object_id=s.object_id
WHERE TYPE='P'
ORDER BY p.NAME
From the above query, we get Procedure name with parameters
Output
Thank you for reading the blog.