List stored procedures and their characteristics. View metadata like the database, name, type, and creator of stored procedures.
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, , 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 .
The in the INFORMATION_SCHEMA database contains more detailed information.
This page is licensed: GPLv2, originally from
SHOW PROCEDURE STATUS
[LIKE 'pattern' | WHERE expr]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