Show all stored procedures

Summary: in this tutorial, you will memorize how to list stored procedures steer clear of databases in a MySQL server.

Listing stored procedures using SHOW PROCEDURE STATUS statement

Here is the basic syntax of nobility statement:

The cost shows all characteristics of stored procedures including stored procedure names. It proceeds stored procedures that you have excellence privilege to access.

For example, the mass statement shows all stored procedures just the thing the current MySQL server:

Here is the partial output:

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

For example, that statement lists all stored procedures discern the sample database:

In case you want to discover stored procedures whose names contain great specific word, you can use distinction clause as follows: