Home › Frequently Asked Questions › Java

How to view all Stored Procedures in a schema?

Posted January 31st, 2008 by administrator
in

<< How to convert ISAM table to MYISAM? | >>

The following sql list the name of all the routines in a given database.

SELECT ROUTINE_NAME

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_TYPE="PROCEDURE" AND ROUTINE_SCHEMA="dbname";

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.

Back to top