How to list Stored Procedures and Functions in MySQL database

How to, Resources, Tips and Tricks, Tutorials
How to check if there are any STORED PROCEDURE in MySQL database? [sourcecode language="sql"]SHOW PROCEDURE STATUS;[/sourcecode] Similarly for MySQL database FUNCTIONS [sourcecode language="sql"]SHOW FUNCTION STATUS;[/sourcecode] But it displays a list of all PROCEDURE and all FUNCTIONS, you can chop down the list by appending [sourcecode language="sql"]## display FUNCTIONS from 'test' db SHOW FUNCTION STATUS WHERE db LIKE ='test';[/sourcecode] Hope it helps somebody. Enjoy!
Read More