Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

3 Answers

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
add comment

UDF are stored in FUNC table of mysql DB.

Try this:

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

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)

http://dev.mysql.com/doc/refman/5.0/en/show-procedure-code.html

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
add comment

Your Answer

 
discard

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.