Find the procedure names where a input keyword(s) is present

Sksamantaray
Posted by Sksamantaray under Sql Server category on | Points: 40 | Views : 1102
When no of procedures are more, its dificult to find out the name of procedures where a paricular keyword is used like, i want to know the name of procedures where the keyword status or a column status is used.

To acheive this following code can be used:

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

Comments or Responses

Login to post response