MariaDB – Polysyncronism

# 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;

# 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;

Category: MariaDB

MariaDB list Functions and Stored Procedures with parameters

MariaDB search for text in database routines