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%'

No comments:

Post a Comment