ApexSQL Clean

Apex SQL Clean tool looks for and deletes unreferenced and unused Database Objects like tables, views and procedures from within the database itself (cross-dependencies) and also from client applications (like a VS.NET project). References are created using proprietary technology that doesn`t rely on SQL system tables. Apex SQL Clean includes a powerful visual Dependency Viewer that converts database dependies into a graphical display. Apex SQL Clean will analyze a client whether it be VB, ASP, Delphi etc to determine what SQL objects are actually being used and what objects aren`t. It will also analyze the database itself to see what internal references exist among SQL objects. Features * [NEW] Column level dependencies * [NEW] Proprietary Dependency parsing algorithms for SQL 7, 2000, 2005 and 2008 that provide accurate dependency Analysis vs native SQL Server methods that use sysdepends table * [NEW] SQL Server 2008 Support * [NEW] Regular expression object filter * Graphical Dependency Viewer * Support for tables, views, procedures, rules, defaults, triggers, user defined datatypes, user defined functions and file dependencies * Interface shows object dependencies and objects with dependencies to it. * Graphical display of number of unreferenced objects. * DDL script for object colorizes referenced object names to allow you to visual spot the dependencies. * Users have the ability to Create file search pattern to analyze all files of a particular language or project (i.e .aspx, .cs, .pas, .cls) * The file processing engine is recursive - simply point to a directory and it will search all subdirectories for files that match the search pattern you create. * Automatic drop statement creation. * Interface shows whether file is referenced, has references and the number of each. Simply clicking on the object will display all references. * Double clicking on any object will script it.