MySQL 5.7 Release Notes
To obtain metadata about stored routines:
Query the
ROUTINEStable of theINFORMATION_SCHEMAdatabase. See Section 24.3.21, “The INFORMATION_SCHEMA ROUTINES Table”.Use the
SHOW CREATE PROCEDUREandSHOW CREATE FUNCTIONstatements to see routine definitions. See Section 13.7.5.9, “SHOW CREATE PROCEDURE Statement”.Use the
SHOW PROCEDURE STATUSandSHOW FUNCTION STATUSstatements to see routine characteristics. See Section 13.7.5.28, “SHOW PROCEDURE STATUS Statement”.Use the
SHOW PROCEDURE CODEandSHOW FUNCTION CODEstatements to see a representation of the internal implementation of the routine. See Section 13.7.5.27, “SHOW PROCEDURE CODE Statement”.