Syntax:
SHOW CREATE {PROCEDURE | FUNCTION} sp_name

These statements are MySQL extensions. Similar to SHOW CREATE TABLE,
they return the exact string that can be used to re-create the named
routine. The statements require that you be the owner of the routine or
have SELECT access to the mysql.proc table.

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

