MySQL 5.5 Reference Manual :: 18 Stored Programs and Views :: 18.2 Using Stored Routines (Procedures and Functions) :: 18.2.3 Stored Routine Metadata
Section Navigation [Toggle]
Metadata about stored routines can be obtained as follows:
Query the
ROUTINEStable of theINFORMATION_SCHEMAdatabase. See Section 19.14, “TheINFORMATION_SCHEMA ROUTINESTable”.Use the
SHOW CREATE PROCEDUREandSHOW CREATE FUNCTIONstatements to see routine definitions. See Section 12.4.5.11, “SHOW CREATE PROCEDURESyntax”.Use the
SHOW PROCEDURE STATUSandSHOW FUNCTION STATUSstatements to see routine characteristics. See Section 12.4.5.29, “SHOW PROCEDURE STATUSSyntax”.
User Comments
Add your own comment.