MySQL in a Nutshell, 2nd Edition

Name

SHOW PROCEDURE STATUS

Synopsis

SHOW PROCEDURE STATUS [LIKE 'pattern'|WHERE expression]

This statement displays information on stored procedures. The LIKE or WHERE clauses can be used to list stored procedures based on a particular naming pattern. With the WHERE clause, you can use the names of fields in the results to create an expression that sets a condition determining the results returned. Here is an example using this statement:

SHOW PROCEDURE STATUS
WHERE Name='students_copy_proc' \G

*************************** 1. row ***************************
           Db: college
         Name: students_copy_proc
         Type: PROCEDURE
      Definer: russell@localhost
     Modified: 2007-11-27 09:27:42
      Created: 2007-11-27 09:27:42
Security_type: DEFINER
      Comment:

Note that for the WHERE clause we use the field name to get the specific stored procedure.