SHOW PROCEDURE STATUS
[LIKE 'pattern' | WHERE expr]
This statement is a MySQL 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 Section 15.7.7.21, “SHOW FUNCTION STATUS Statement”).
To use either statement, you must be the user named as the
routine DEFINER
, have the
SHOW_ROUTINE
privilege, have the
SELECT
privilege at the global
level, or have the CREATE
ROUTINE
, ALTER ROUTINE
,
or EXECUTE
privilege granted at a
scope that includes the routine.
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
Section 28.8, “Extensions to SHOW Statements”.
mysql> SHOW PROCEDURE STATUS LIKE 'sp1'\G
*************************** 1. row ***************************
Db: test
Name: sp1
Type: PROCEDURE
Definer: testuser@localhost
Modified: 2018-08-08 13:54:11
Created: 2018-08-08 13:54:11
Security_type: DEFINER
Comment:
character_set_client: utf8mb4
collation_connection: utf8mb4_0900_ai_ci
Database Collation: utf8mb4_0900_ai_ci
mysql> SHOW FUNCTION STATUS LIKE 'hello'\G
*************************** 1. row ***************************
Db: test
Name: hello
Type: FUNCTION
Definer: testuser@localhost
Modified: 2020-03-10 11:10:03
Created: 2020-03-10 11:10:03
Security_type: DEFINER
Comment:
character_set_client: utf8mb4
collation_connection: utf8mb4_0900_ai_ci
Database Collation: utf8mb4_0900_ai_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.
Stored routine information is also available from the
INFORMATION_SCHEMA
PARAMETERS
and
ROUTINES
tables. See
Section 28.3.20, “The INFORMATION_SCHEMA PARAMETERS Table”, and
Section 28.3.30, “The INFORMATION_SCHEMA ROUTINES Table”.