views:

79

answers:

3

Is there any way to display all of the stored procedures in a database?

+7  A: 

select * from sys.procedures

Ray
+1 direct filter on the procedures.
George
+2  A: 
SELECT * 
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE'
AdaTheDev
A: 

here is other way:

SELECT name
FROM sys.objects
WHERE type = 'P'
sanjeev40084