Wednesday 4 December 2013

List of SP or Function containing specific text

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
    FROM INFORMATION_SCHEMA.ROUTINES
    WHERE ROUTINE_DEFINITION LIKE '%searchtext%'
   -- AND ROUTINE_TYPE='PROCEDURE'

No comments:

Post a Comment