SHOW PROCEDURE STATUS

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

The SHOW PROCEDURE STATUS statement returns information about a stored procedure, including its database, name, type, creator, creation and modification dates, and character set.

To use this statement, you must satisfy at least one of the following conditions:

• Be the user specified as the DEFINER of the routine.
• Have the SHOW_ROUTINE privilege.
• Have the SELECT privilege at the global level.
• Have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege on the routine.

The optional LIKE clause filters procedure (or function) names by pattern, and the WHERE clause can be used to select rows using more general conditions.

For more information, see the MySQL documentation: SHOW PROCEDURE STATUS Statement.