Previous Posts By Category
This program is designed to find orphaned database objects that usually happen over many software revisions and are even more common with poor documentation. What it does is, it accesses your database and retrieves a list of all the database objects: tables, stored procedures, views, etc. and then it can scan your application and/or web source for references to these objects. It then generates a report that lists all the found objects, how many times they were found, if they were found in the application source and/or the web source, and the last place it was found.
Once the scanner is done analyzing your database, it generates a report and from which you can see which objects are no longer in use in your code and can be removed. Plus on top of that, if something is found only once it tells you where and you can view your code to see if it is still needed. You can view a sample copy of the report if you'd like.
It supports Access, Microsoft SQL Server, and MySQL databases.
Here are all related files in the database for Database Object Scanner.