MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
Metadata about stored routines can be obtained as follows:
Query the
ROUTINES
table of theINFORMATION_SCHEMA
database. See Section 25.23, “The INFORMATION_SCHEMA ROUTINES Table”.Use the
SHOW CREATE PROCEDURE
andSHOW CREATE FUNCTION
statements to see routine definitions. See Section 13.7.6.9, “SHOW CREATE PROCEDURE Syntax”.Use the
SHOW PROCEDURE STATUS
andSHOW FUNCTION STATUS
statements to see routine characteristics. See Section 13.7.6.28, “SHOW PROCEDURE STATUS Syntax”.