(mysql.info.gz) SHOW PROCEDURE STATUS
Info Catalog
(mysql.info.gz) Maintaining Stored Procedures
(mysql.info.gz) Stored Procedure Syntax
(mysql.info.gz) CALL
19.1.2 `SHOW PROCEDURE STATUS' and `SHOW FUNCTION STATUS'
---------------------------------------------------------
SHOW {PROCEDURE | FUNCTION} STATUS [LIKE 'PATTERN']
This statement is a MySQL extension. It returns characteristics of
routines, such as the database, name, type, creator, and creation and
modification dates. If no pattern is specified, the information for all
stored procedures or all stored functions is listed, depending on which
statement you use.
mysql> SHOW FUNCTION STATUS LIKE 'hello'\G
*************************** 1. row ***************************
Db: test
Name: hello
Type: FUNCTION
Definer: testuser@localhost
Modified: 2004-08-03 15:29:37
Created: 2004-08-03 15:29:37
Security_type: DEFINER
Comment:
Info Catalog
(mysql.info.gz) Maintaining Stored Procedures
(mysql.info.gz) Stored Procedure Syntax
(mysql.info.gz) CALL
automatically generated byinfo2html