Metadata about stored routines can be obtained as follows:
ROUTINEStable of the
INFORMATION_SCHEMAdatabase. See Section 20.16, “The INFORMATION_SCHEMA ROUTINES Table”.
INFORMATION_SCHEMAdoes not have a
PARAMETERStable until MySQL 5.5, so applications that need to acquire routine parameter information at runtime must use workarounds such as parsing the output of
SHOW CREATEstatements or the
param_listcolumn of the
param_listcontents can be processed from within a stored routine, unlike the output from