(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