How to check if there are any STORED PROCEDURE in MySQL database?
SHOW PROCEDURE STATUS;
Similarly for MySQL database FUNCTIONS
SHOW FUNCTION STATUS;
But it displays a list of all PROCEDURE and all FUNCTIONS, you can chop down the list by appending
## display FUNCTIONS from 'test' db SHOW FUNCTION STATUS WHERE db LIKE ='test';
Hope it helps somebody.
Enjoy!