Breaking News
Home / Sys Admin / Mysql / How to view all Stored Procedures in a Schema?

How to view all Stored Procedures in a Schema?

mysql Stored Procedure 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”;

[pb_builder]

Check Also

How to repair table marked as crashed in MySQL?

MySQL is a very common choice for webmasters and is pretty good and stable database. …

Advertisment ad adsense adlogger