Reminder to Self - MySQL, List stored procedures

May 19, 2008 in programming | No comments

I just spent 10 minutes tracking down this particularly opaque MySQL command:

SHOW PROCEDURE STATUS

Followup. To list views:

SELECT * FROM information_schema.views

To list stored procedures and functions:

SELECT * FROM information_schema.routines

I really should have these bits and pieces committed to memory already, but as most of my job currently consists of fire-fighting in other peoples’ code, I don’t get to use sensible features like SPs and views very often.

Tags: ,