Metadata about stored routines can be obtained as follows:
Query the
ROUTINEStable of theINFORMATION_SCHEMAdatabase. See Section 20.14, “TheINFORMATION_SCHEMA ROUTINESTable”.Use the
SHOW CREATE PROCEDUREandSHOW CREATE FUNCTIONstatements to see routine definitions. See Section 12.4.5.11, “SHOW CREATE PROCEDURESyntax”.Use the
SHOW PROCEDURE STATUSandSHOW FUNCTION STATUSstatements to see routine characteristics. See Section 12.4.5.29, “SHOW PROCEDURE STATUSSyntax”.