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?

possible duplicate of [View stored procedure/function definition in MySQL](http://stackoverflow.com/questions/1968773/view-stored-procedure-function-definition-in-mysql) — David Harkness, Jul 06 '14 at 23:38

score 18 · Answer 1 · answered Aug 24 '12 at 07:44

18

try "SHOW CREATE PROCEDURE procedurename"

answered Aug 24 '12 at 07:44

codelization

189
3

1

**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 Apr 08 '14 at 05:57
2

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 Apr 08 '14 at 06:04

score 7 · Answer 2 · answered Oct 18 '13 at 11:53

7

Yes,

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

answered Oct 18 '13 at 11:53

Christoph

1,993
1
25
33

This **shows what the function/procedure CONTAINS** - what is to be executed, not the whole "create function/procedure" code. – jave.web Apr 08 '14 at 06:05

score 0 · Answer 3 · answered Aug 24 '12 at 07:42

0

You can get the information form the INFORMATION_SCHEMA.ROUTINES table

answered Aug 24 '12 at 07:42

Maxim Krizhanovsky

26,265
5
59
89

score 0 · Answer 4 · edited Dec 21 '20 at 14:07

I've been experimenting a bit, and I think one of the following two works best.

To list everything (parameters, collating, etc.), use this.

 SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA in (SELECT DATABASE()) AND ROUTINE_NAME='ProcedureName';

To list only the code, use this.

SELECT ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA in (SELECT DATABASE()) AND ROUTINE_NAME='ProcedureName';

In both of the above, the nested select is required to limit the result to the current database, since INFORMATION_SCHEMA, being the system database, contains details for every database installed in the instance.

score 0 · Answer 5 · edited Dec 20 '18 at 08:56

0

Go to mySQL workbench

Right click on procedure and then select ALTER. (This Will open the definition of procedure for you(is the easiest way).

OR

You can also use the command, SHOW CREATE PROCEDURE proc_name;

edited Dec 20 '18 at 08:56

Ali

2,702
3
32
54

answered Dec 20 '18 at 02:39

Raman Verma

1

Show procedure/function code in MySql

5 Answers5