How to list stored procedure for a database in MySql

A stored procedure is a set of Structured Query Language (SQL) statements with an assigned name, which are stored in a relational database management system as a group, so it can be reused and shared by multiple programs.

In-order to list stored procedure for a database in MySql, we can use the following query.

SHOW PROCEDURE STATUS WHERE db = 'database';

Here we need to replace 'database' with the name of the required database.

Leave a Reply

Your email address will not be published. Required fields are marked *