Name of all the stored procedures in the database

Suggest a feature

Please login or create account to add a snippet.

Follow @TagMyCode

Language: T-SQL

Posted by: tausif alam

Added: Apr 25, 2016 8:41 AM

Tags: storedprocedure tsql

The following query returns all the name of the stored procedure in the database

As Mike stated, the best way is to use information_schema. As long as you're not in the master database, system stored procedures won't be returned.
select *
from DatabaseName.information_schema.routines
where routine_type = 'PROCEDURE'
If for some reason you had non-system stored procedures in the master database, you could use the query (this will filter out MOST system stored procedures):
select *
from master.information_schema.routines
where routine_type = 'PROCEDURE'
and Left(Routine_Name, 3) NOT IN ('sp_', 'xp_', 'ms_')