Finding in routines or triggers

TomasB's profile image TomasB posted 8 years ago in Feature discussion Permalink

Hi Ansgar, now I can find text in tables.

I would appreciate new feature - find routine or trigger by definition. Something like:

SELECT routine_schema, routine_name FROM information_schema.routines WHERE routine_definition LIKE '%find_me_in_def%'

SELECT trigger_schema, trigger_name, event_manipulation, event_object_table FROM information_schema.triggers WHERE action_statement LIKE '%find_me_in_def%'

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