Apex SQL 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. Based on the Apex SQL Clean analysis it will generate a file of SQL drop statements to Clean your database of these useless objects. Features - 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 .cs, .vb, .frm, .aspx, .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. - Interface supports grouping/ungrouping by object type.