MySQL 8.4 Release Notes
要获取存储例程的元数据：To obtain metadata about stored routines:
查询
INFORMATION_SCHEMA数据库的ROUTINES表。参见 第 28.3.30 节，“INFORMATION_SCHEMA ROUTINES 表”。Query theROUTINEStable of theINFORMATION_SCHEMAdatabase. See Section 28.3.30, “The INFORMATION_SCHEMA ROUTINES Table”.使用
SHOW CREATE PROCEDURE和SHOW CREATE FUNCTION语句查看例程定义。参见 第 15.7.7.10 节，“SHOW CREATE PROCEDURE 语句”。Use theSHOW CREATE PROCEDUREandSHOW CREATE FUNCTIONstatements to see routine definitions. See Section 15.7.7.10, “SHOW CREATE PROCEDURE Statement”.使用
SHOW PROCEDURE STATUS和SHOW FUNCTION STATUS语句查看例程特性。请参见 第 15.7.7.30 节，“SHOW PROCEDURE STATUS 语句”。Use theSHOW PROCEDURE STATUSandSHOW FUNCTION STATUSstatements to see routine characteristics. See Section 15.7.7.30, “SHOW PROCEDURE STATUS Statement”.使用
SHOW PROCEDURE CODE和SHOW FUNCTION CODE语句来查看例程内部实现的表示。参见 第 15.7.7.29 节，“SHOW PROCEDURE CODE 语句”。Use theSHOW 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”.