Syntax
------ 
SHOW PROCEDURE STATUS
 [LIKE 'pattern' | WHERE expr]
 
Description
----------- 
This statement is a MariaDB 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.
 
The LIKE clause, if present, indicates which procedure or
function names to match. The WHERE and LIKE clauses can be
given to select rows using more general conditions, as
discussed in Extended SHOW.
 
The ROUTINES table in the INFORMATION_SCHEMA database
contains more detailed information.
 
Examples
-------- 
SHOW PROCEDURE STATUS LIKE 'p1'\G
*************************** 1. row
***************************
 Db: test
 Name: p1
 Type: PROCEDURE
 Definer: root@localhost
 Modified: 2010-08-23 13:23:03
 Created: 2010-08-23 13:23:03
 Security_type: DEFINER
 Comment: 
character_set_client: latin1
collation_connection: latin1_swedish_ci
 Database Collation: latin1_swedish_ci
 


URL: https://mariadb.com/kb/en/show-procedure-status/