Show procedure/function code in MySql

Question

Is there any options to view stored procedure/function code in MySql same as like "sp_helptext procedurename" in sql?

Solution 1

try "SHOW CREATE PROCEDURE procedurename"

Solution 2

Yes,

SELECT ROUTINE_DEFINITION FROM information_schema.ROUTINES WHERE SPECIFIC_NAME='procedurename'

Comments

[jave.web]

1. SHOW with CREATE is usually available, (just SHOW is only available in debug mode)........................ 2. This shows the whole CREATE code of the function/procedure.

[jave.web]

Also note that of course you can switch procedure keyword with function to get the function create code::::: SHOW CREATE FUNCTION function_name

[jave.web]

This shows what the function/procedure CONTAINS - what is to be executed, not the whole "create function/procedure" code.