Procedure Data Dictionary « Procedure Function « MySQL Tutorial

11.46.Procedure Data Dictionary
11.46.1.Viewing Stored Procedures
11.46.2.Viewing Stored Procedures with a LIKE clause
11.46.3.To get more details on a stored procedure, use the SHOW CREATE PROCEDURE statement:
11.46.4.Use SELECT statement to access on the proc table in the mysql database
11.46.5.Show the procedure's database, name, language, security type, parameter list, body, definer, comment, and other information