Google apps

Main menu

Post a Comment On: Blogpad

"Find specific text in stored procedures"

No comments yet. -

1 – 0 of 0

From http://databases.aspfaq.com/database/how-do-i-find-a-stored-procedure-containing-text.html

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

select * from information_schema.routines
where ROUTINE_DEFINITION LIKE '%foobar%'

posted by fc at 9:21 AM on Aug 9, 2009

Leave your comment

You can use some HTML tags, such as <b>, <i>, <a>

This blog does not allow anonymous comments.

Google Account

You will be asked to sign in after submitting your comment.

Please prove you're not a robot