CODE EXAMPLE FOR SQL

select * from mysql.proc

-- for list of procedures
SHOW PROCEDURE STATUS;