如果表名比较唯一且特殊，可以这样 

SELECT * FROM information_schema.Routines WHERE routine_type = 'PROCEDURE'
and routine_definition like '%your_tablename%';