1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
# 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 search for text in database routines
1 2 |
SELECT ROUTINE_NAME FROM `information_schema`.`ROUTINES` WHERE `ROUTINE_DEFINITION` LIKE '%mysearchhere%'; |