Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do I display all the UDFs (User Definied Functions) on a MySQL server? (version 5.0.x)

UPDATE I don't want to display the code of all the UDFs, I just want to list the name of each UDF that is installed. Sorta like SHOW DATABASES, but for UDFs.

share|improve this question
up vote 1 down vote accepted

All procedures are stored in the mysql db. I usually use this query when I'm looking for something.

select db,name,definer,modified from mysql.proc;

share|improve this answer

UDF are stored in FUNC table of mysql DB.

Try this:

 select * from mysql.func;
share|improve this answer

According to the docs it looks like you can't do this without debugging enabled in the build.

See: (This page is for functions as well as procs)

share|improve this answer
TBH I don't want to display the code, I just want to see the name of all the functions installed. – Rory Aug 9 '09 at 16:28

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.