Skip to content

Instantly share code, notes, and snippets.

@shiranGinige

shiranGinige/Search text within Stored Procs

Created June 21, 2017 06:48
Show Gist options
  • Save shiranGinige/a10b797f42fa6814bbb3cbf150e9fa29 to your computer and use it in GitHub Desktop.
Save shiranGinige/a10b797f42fa6814bbb3cbf150e9fa29 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Search text within Stored Procs
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%search text%'
AND ROUTINE_TYPE='PROCEDURE'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment