Showing posts with label stored procedure search. Show all posts
Showing posts with label stored procedure search. Show all posts

Thursday, 24 March 2011

Find text in Stored Procedures

The following query returns all delete stored procedures with a delete clause;



SELECT
*
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
ROUTINE_TYPE = 'PROCEDURE'
AND ROUTINE_DEFINITION LIKE '%DELETE%'