MySQL 8.3 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.30, “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.29, “SHOW PROCEDURE CODE Statement”.