SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr]
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.
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
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/show-procedure-status/