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;