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