MYSQL request for all Stored Procedures that call a certain table

I need to see if I can wipe a table without breaking other stored procedures.

In MySQL is it possible to query the system to find all Stored Procedures that reference a certain table.  

Sorry I do not know the version on MySQl that is being used.
onaled777Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gheistCommented:
stored procedures are programs, so MySQL has no clue what is in them until executed.
0
PortletPaulfreelancerCommented:
You may need to learn what version you are using.

It is possible to get a list of stored procs:

      SHOW PROCEDURE STATUS
(nb: I believe this could be used to create a set of show procedure code statements dynamically)


Then it is possible to display the code of each stored proc.

     SHOW PROCEDURE CODE proc_name
SHOW PROCEDURE CODE was added in MySQL 5.0.17.
However, I'm not sure how to search through this output to suit your specific need
0
Steve BinkCommented:
This isn't something you can do with 100% accuracy, but this query will narrow it down for you:
select db,name,type from mysql.proc where body like '%MyTableName%';

Open in new window

Just replace "MyTableName" with the name of the table.  Note that this is a text search through the body of the procedure, so if the table name appears in comments, or even as a substring of another identifier, it will show in the return.
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.