MariaDB tips and tricks
This is part of a series of quick tips and tricks I have accumulated over the year, that I think can be useful for others.
If you have similar short tips and tricks please leave a comment.
Find stored procedure
When working on large databases there can in some projects be hundreds or even thousands of stored procedures, so if your task is to find all stored procedures that query a specific table then finding it could be quite a headache.
This query below has helped me many times and I hope it will help you too.
SELECT r.ROUTINE_SCHEMA as "Database",
r.ROUTINE_NAME
FROM information_schema.routines r
WHERE r.ROUTINE_TYPE = 'PROCEDURE'
AND r.ROUTINE_DEFINITION LIKE '%departments%'
ORDER BY r.ROUTINE_SCHEMA ASC,
r.ROUTINE_NAME ASC;
Top comments (0)