MySQL - How to show all stored procedures or functions?
To show all stored procedures:
SHOW PROCEDURE STATUS;
To show all stored functions:
SHOW FUNCTION STATUS;
These statement will show a list of stored procedures and functions, but shows all of them, server-wide.
If you want to show stored procedures in a specific database:
SHOW PROCEDURE STATUS WHERE Db = 'db_name';
The same with functions:
SHOW FUNCTION STATUS WHERE Db = 'db_name';
Need a good GUI Tool for MySQL? TablePlus is a modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.
