May
26
How to list Stored Procedures and Functions in MySQL database
Posted by | Posted in How to, Resources, Tips and Tricks, Tutorials | Posted on 26-05-2009
Tagged Under : Functions, MySQL, MySQL 5.0, Stored Procedures
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!


