How can we see the list of stored procedures and stored functions in a particular MySQL database?

We can see the list of the stored procedure and stored functions in a particular database by using the following query on INFORMATION_SCHEMA.ROUTINES as follows −

mysql> SELECT ROUTINE_TYPE, ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = 'query';
+--------------+--------------+
| ROUTINE_TYPE | ROUTINE_NAME |
+--------------+--------------+
| PROCEDURE    | allrecords   |
| FUNCTION     | Hello        |
+--------------+--------------+
2 rows in set (0.04 sec)

The above query returns the procedure named ‘allrecords’, and function named ‘Hello’ which are stored in the database named ‘query’.

Sreemaha

Published on 21-Feb-2018 07:36:40

• Related Questions & Answers
• How can we see only the list of stored procedures in a particular MySQL database?
• How can we see only the list of stored functions in a particular MySQL database?
• How can we see the list, along with other information, stored procedures in a particular MySQL database?
• How can we see the list, along with complete information, of stored procedures in a particular MySQL database?
• How can we see the list of views stored in a particular MySQL database?
• How can we see the list, along with complete information, of stored functions in a particular MySQL database?
• How can we see the list, along with some other information, of stored functions in a particular MySQL database?
• How can we see the metadata of a view(s) stored in a particular MySQL database?
• How can we see only name and types of the stored routines in a particular MySQL database?
• How can we see the source code of a particular MySQL stored function?
• How can we see the source code of a particular MySQL stored procedure?
• What is stored procedure and how can we create MySQL stored procedures?
• How can we access tables through MySQL stored procedures?
• What are the differences between Stored procedures and functions?
• How can we delete a MySQL stored function from the database?