Snippet

SQL List All Stored Procedures

List every stored procedure in a database using INFORMATION_SCHEMA.ROUTINES.

March 20, 20121 min read#SQL

This query uses the information schema.

sql

SELECT * FROM
DatabaseName.information_schema.routines
WHERE routine_type = 'PROCEDURE'

Functions are listed in the same view with a routine_type of FUNCTION.