Posts Tagged ‘stored procedure’

h1

Fetch stored procedure which contains “text”

June 4, 2015

Code :

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE ‘%texttosearch%’
AND ROUTINE_TYPE = ‘PROCEDURE’
Advertisements