Get all stored procedures in sql server using a table

Summary: in this tutorial, you will learn how to list stored procedures from databases in a MySQL server.

Listing stored procedures using SHOW PROCEDURE STATUS statement

Here is the basic syntax of the statement:

The statement shows all characteristics of stored procedures including stored procedure names.

It returns stored procedures that you have the privilege to access.

For example, the following statement shows all stored procedures in the current MySQL server:

Here is the partial output:

If you just want to show stored procedures in a particular database, you can use a clause in the  as shown in the following statement:

For example, this statement lists all stored procedures in the sample database:

In case you want to find stored procedures whose names contain a specific word, you can use the clause as follows: