MySQL -- This show all existing stored procedures for db SHOW PROCEDURE STATUS where Db = 'gctologs'; -- this show full create script. So you could see what this procedure do SHOW CREATE PROCEDURE join_gtt_table; SQL MySQL