How can I Display a stored procedure 2

[flubbard]

I am new to stored procedures. This seems like a very basic question but I have not been able to find the answer. Once a stored procedure has been created, how can I display its contents. I know how to run it and the show procedure status shows which procedures are defined, but the actual code for the procedure is not shown.

Any help would be apperciated.

Thanks,
Flub

 

[sleipnir214]

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

Want the best answers? Ask the best questions! TANSTAAFL!

 

[flubbard]

Thank you. That was exactly what I was looking for.

- flub