Show procedure definition in MySQL

Asked 2009-12-28T10:06:24.463

108

What is the MySQL command to show the definition of a procedure, similar to sp_helptext in Microsoft SQL Server?

I know that SHOW PROCEDURE STATUS will display the list of the procedures available. I need to see a single procedure's definition.

sql mysql database stored-procedures stored-functions

Edit Report

1 Answer

If you want to know the list of procedures you can run the following command -

show procedure status;

It will give you the list of procedures and their definers Then you can run the show create procedure <procedurename>;

answered 2012-06-26T19:00:13.390