Syntax:
SHOW PROCEDURE STATUS
    [LIKE 'pattern' | WHERE expr]

This statement is a MySQL extension. It returns characteristics of a
stored procedure, such as the database, name, type, creator, creation
and modification dates, and character set information. A similar
statement, SHOW FUNCTION STATUS, displays information about stored
functions (see [HELP SHOW FUNCTION STATUS]).

To use either statement, you must be the user named as the routine
DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at
the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE
privilege granted at a scope that includes the routine.

The LIKE clause, if present, indicates which procedure or function
names to match. The WHERE clause can be given to select rows using more
general conditions, as discussed in
https://dev.mysql.com/doc/refman/8.0/en/extended-show.html.

URL: https://dev.mysql.com/doc/refman/8.0/en/show-procedure-status.html

