Query SQL Stored Procedure Body for some Text

Summary

This post contains a SQL statement to query a stored procedure where the body of the procedure contains some text string.

SQL


1
2
3
4
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_DEFINITION LIKE '%Foo%' 
AND ROUTINE_TYPE='PROCEDURE'

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)
} else { }