Category: MariaDB

# list all routines with type and parameter list.
# parameters are comma separated and listed by ordinal_position
select r.routine_schema as database_name,
       r.specific_name as routine_name,
       r.routine_type AS type,
       GROUP_CONCAT(p.parameter_name ORDER BY p.ordinal_position) AS Parameters
from information_schema.routines r
left join information_schema.parameters p
          on p.specific_schema = r.routine_schema
          and p.specific_name = r.specific_name
where r.routine_schema not in ('sys', 'information_schema',
                               'mysql', 'performance_schema')
     and r.routine_schema = 'warehouse' # Your database name here
GROUP BY r.specific_name     
order by r.routine_schema,
         r.specific_name,
         p.ordinal_position;

SELECT ROUTINE_NAME FROM `information_schema`.`ROUTINES` 
WHERE `ROUTINE_DEFINITION` LIKE '%mysearchhere%';