Find and list all MySQL tables available in scripts

Question

We are restructuring our database, and we need to find all the tables referenced by our PHP scripts. I was considering SQL Parser, but I need to know the specific files in which the tables occur. In both cases, below you need to find the contacts table, and then list the location of the script.

 SELECT * FROM contacts WHERE... SELECT * FROM `contacts` WHERE... 

Answer 1

Try PHPStorm. It has the "Database Tools" feature. After setting up, you can use the "Search Usage" function to track all of your table links in your project.

More here