search text inside all procedures

632 posts
BubikolRamios's profile image BubikolRamios posted 12 years ago in General Permalink
Is that possible to do in HSQL, if not that would be feature request.
21 posts
[expired user #4867]'s profile image [expired user #4867] posted 12 years ago Permalink
I don't think HeidiSQL can do this, but it's easy enough to do it with a regular query:

SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA='yourDB' AND ROUTINE_BODY LIKE '%search%';

Please login to leave a reply, or register at first.