MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
SHOW PROCEDURE STATUS [LIKE 'pattern
' | WHEREexpr
]
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 13.7.5.21, “SHOW FUNCTION STATUS Statement”).
To use either statement, you must be the owner of the routine or
have SELECT
access to the
mysql.proc
table.
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 21.35, “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: utf8 collation_connection: utf8_general_ci Database Collation: latin1_swedish_ci mysql>SHOW FUNCTION STATUS LIKE 'hello'\G
*************************** 1. row *************************** Db: test Name: hello Type: FUNCTION Definer: testuser@localhost Modified: 2020-03-10 11:14:27 Created: 2020-03-10 11:14:27 Security_type: DEFINER Comment: character_set_client: utf8 collation_connection: utf8_general_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.
Stored routine information is also available from the
INFORMATION_SCHEMA
PARAMETERS
and
ROUTINES
tables. See
Section 21.13, “The INFORMATION_SCHEMA PARAMETERS Table”, and
Section 21.19, “The INFORMATION_SCHEMA ROUTINES Table”.