SHOW PROCEDURE STATUS
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
See Also
This page is licensed: GPLv2, originally from fill_help_tables.sql
Last updated
Was this helpful?