How can we see only name and types of the stored routines in a particular MySQL database?

MySQLMySQLi Database

We can write the following query to see only the name and types of procedures in a particular MySQL database. To make it understand we are using the database named ‘query’ −

mysql> Select Name, Type from mysql.proc where db = 'query';
| Name       | Type      |
| allrecords | PROCEDURE |
| Hello      | FUNCTION  |
2 rows in set (0.18 sec)
Updated on 22-Jun-2020 05:16:12