List of Stored Procedures/Functions Mysql Command Line

SHOW PROCEDURE STATUS;
SHOW FUNCTION STATUS;

show procedure status

will show you the stored procedures.

show create procedure MY_PROC

will show you the definition of a procedure. And

help show

will show you all the available options for the show command.

For view procedure in name wise

select name from mysql.proc

below code used to list all the procedure and below code is give same result as show procedure status

select * from mysql.proc

A more specific way:

SHOW PROCEDURE STATUS 
WHERE Db = DATABASE() AND Type = 'PROCEDURE'

Related