INFORMATION_SCHEMA.ROUTINES
SELECT ROUTINE_TYPE,ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA='dbname';