Suggest a feature
×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: matias s..
Added: Nov 27, 2020 6:19 PM
Modified: Nov 27, 2020 6:20 PM
Views: 7
  1. SELECT *
  2. FROM
  3. information_schema.routines R
  4. WHERE
  5. R.ROUTINE_TYPE ='PROCEDURE'
  6. AND R.ROUTINE_SCHEMA = 'db_name'
  7. AND R.ROUTINE_DEFINITION LIKE '%string_to_search%';
Comments disabled