SHOW PROCEDURE STATUS
Syntax
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 (see , "SHOW FUNCTION STATUS
Syntax").
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 , "Extensions to SHOW
Statements".
mysql> SHOW PROCEDURE STATUS LIKE 'sp1'\G
*************************** 1. row ***************************
Db: test
Name: sp1
Type: PROCEDURE
Definer: testuser@localhost
Modified: 2004-08-03 15:29:37
Created: 2004-08-03 15:29:37
Security_type: DEFINER
Comment:
character_set_client: latin1
collation_connection: latin1_swedish_ci
Database Collation: latin1_swedish_ci
character-set-client
is the session value of the character_set_client
system variable when the routine was created. collation_connection
is the session value of the collation_connection
system variable when the routine was created. Database Collation
is the collation of the database with which the routine is associated.
You can also get information about stored routines from the ROUTINES
table in INFORMATION_SCHEMA
. See , "The INFORMATION_SCHEMA ROUTINES
Table".