Truy vấn INFORMATION_SCHEMA.ROUTINES lọc theo ROUTINE_TYPE = 'PROCEDURE':
mysql> SELECT ROUTINE_TYPE, ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_SCHEMA = 'query' AND ROUTINE_TYPE = 'PROCEDURE';
+--------------+------------------------+
| ROUTINE_TYPE | ROUTINE_NAME |
+--------------+------------------------+
| PROCEDURE | allrecords |
+--------------+------------------------+
1 row in set (0.05 sec)