Stored Routine Metadata

Metadata about stored routines can be obtained as follows:

• Query the ROUTINES table of the INFORMATION_SCHEMA database. See , "The INFORMATION_SCHEMA ROUTINES Table".
• Use the SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION statements to see routine definitions. See , "SHOW CREATE PROCEDURE Syntax".
• Use the SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS statements to see routine characteristics. See , "SHOW PROCEDURE STATUS Syntax".

Retornar