Metadata about stored routines can be obtained as follows:
Query the
ROUTINEStable of theINFORMATION_SCHEMAdatabase. See Section 19.14, “TheINFORMATION_SCHEMA ROUTINESTable”.Use the
SHOW CREATE PROCEDUREandSHOW CREATE FUNCTIONstatements to see routine definitions. See Section 12.5.5.11, “SHOW CREATE PROCEDURESyntax”.Use the
SHOW PROCEDURE STATUSandSHOW FUNCTION STATUSstatements to see routine characteristics. See Section 12.5.5.30, “SHOW PROCEDURE STATUSSyntax”.INFORMATION_SCHEMAdoes not have aPARAMETERStable until MySQL 5.4, so applications that need to acquire routine parameter information at runtime must use workarounds such as parsing the output ofSHOW CREATEstatements or theparam_listcolumn of themysql.proctable.param_listcontents can be processed from within a stored routine, unlike the output fromSHOW.
User Comments
Add your own comment.