Check if a MySQL database has any stored procedures

Question

I am trying to figure out the best way to determine if a mysql database uses stored procs or not. It's not a home grown database... open source stuff. I found another post here: Find all MySQL Stored Procedure calls?

Based on that post, I've tried the following:

mysql> SELECT * FROM information_schema.ROUTINES
    -> ; Empty set (0.00 sec)

mysql>

Can I safely assume then that this database has no stored procs? Thanks!

Unless you are 'root' I think you can only assume that there are no procs that you have access to. — ethrbunny
– ethrbunny, Commented Apr 3, 2013 at 12:54

Adam Erstelle · Accepted Answer · 2013-04-03 13:27:52Z

1

With the Query you posted, you are correct in making that assumption. I tested it on a local database with no Stored Procs and got the same result. I created a test stored proc, re-ran that same query and got a single result (with the proc I created).

answered Apr 3, 2013 at 13:27

Adam Erstelle

2,5233 gold badges24 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Check if a MySQL database has any stored procedures

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related