Display all stored procedures containing a string


Display all stored procedures containing a string

Programmers always have trouble in finding out the exact stored procedure if you don't have proper documentation.


Beow query will help to find out all the stored procedures containing a particular string.


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


if you execute above stored procedure result will be the list of stored procedure containing the string User_ID.


Comments

No responses found. Be the first to comment...


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: