Home > SQL

Search for text in stored procedures

30. September 2011

I’m tried of searching for this all the time. So here is where I’m storing it. ^_^

 

SELECT ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITION
    FROM INFORMATION_SCHEMA.ROUTINES
    WHERE ROUTINE_DEFINITION LIKE '%text%'
    AND ROUTINE_TYPE='PROCEDURE'
    ORDER BY ROUTINE_SCHEMA, ROUTINE_NAME

 

Just replace text with whatever you are looking for. But this does not search for functions or such.

SQL

Add comment




biuquote
  • Comment
  • Preview
Loading