How to Retrieve names of stored procedures in SQL Server?

Question

Is there any way to retrieve the names of the stored procedures by some SELECT from the system table or any system SP?

I need to retrieve all the stored procedure names with their signatures (if possible) or just names. I know how to do that in MySql, but similar queries don't work (of course, since all the system DBs named differently).

Thank you!

David M · Accepted Answer · 2009-07-08 08:56:37Z

This should do it:

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

The ANSI way (which will work on both MySQL and MS SQL) is:

SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE'

super9 · Accepted Answer · 2009-07-08 08:56:51Z

2

Not sure if this would work in MySQL but it works in MS SQL.

exec sp_stored_procedures

answered Jul 8, 2009 at 8:56

super9

30.2k41 gold badges125 silver badges172 bronze badges

Comments

fancyPants · Accepted Answer · 2012-08-30 11:08:16Z

0

SELECT * FROM sysobjects WHERE type=’p’

edited Aug 30, 2012 at 11:08

fancyPants

52.1k34 gold badges94 silver badges100 bronze badges

answered Jul 8, 2009 at 8:58

Andrew Siemer

10.3k3 gold badges44 silver badges61 bronze badges

Collectives™ on Stack Overflow

How to Retrieve names of stored procedures in SQL Server?

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related