Listing stored procedures in MySQL

MySQL Best Practices

In MySQL you can list or show all stored procedures and manage more efficiently.

Display source code of stored procedure:

Use SHOW CREATE PROCEDURE statement to display source code of a particular stored procedure.

SHOW CREATE PROCEDURE GetAllUsers;

Display characteristics of stored procedure:

Use SHOW PROCEDURE STATUS to list all stored procedures.

SHOW PROCEDURE STATUS WHERE name = ‘GetAllUsers’;

For any types of queries, you can contact us on info@namasteui.com.

You may like:  MySQL export table to CSV

Leave a Reply

Your email address will not be published. Required fields are marked *