ApexSQL Clean 2005.07
ApexSQL Clean looks for and deletes unreferenced and unused Database objects like tables, views and procedures.
|
ApexSQL Clean looks for and deletes unreferenced and unused Database objects like tables, views and procedures.
If database object bloat is the problem, ApexSQL Clean is the solution. Your database may have many stored procedures, tables and views that aren't being used anymore but unless you determine which of your objects fall into this category you will be stuck with them forever.
ApexSQL Clean will analyze a client whether it be ASP, Delphi, VB 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 this 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 .frm, .asp, .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.
Requirements
Limitations
tags
apexsql clean interface shows search pattern object will user defined sql objects tables views your database being used

Download ApexSQL Clean 2005.07
Download ApexSQL Clean 2005.07
Purchase:
Buy ApexSQL Clean 2005.07
Similar software
ApexSQL Clean 2005.07
Apex SQL tools
ApexSQL Clean looks for and deletes unreferenced and unused Database objects like tables, views and procedures.
ApexSQL Developer Studio
Apex SQL Tools
All Per-client licensed Developer tools including : ApexSQL Code, ApexSQL Audit, ApexSQL Script, ApexSQL Clean, ApexSQL Diff, ApexSQL Edit, ApexSQL Doc.
SQLClean 2.3.76
Lockwood Technical Services, I
If database object bloat is the problem, SQLClean is the solution.
ApexSQL Script 2005.04
Apex SQL tools
ApexSQL Script creates insert scripts from any Microsoft® SQL Server© 7 or 2 database that can be archived, emailed, checked into source control, run against another database etc.
microOLAP Database Designer for PostgreSQL 1.2.8
microOLAP Technologies LTD
Database Designer for PostgreSQL is an easy and useful CASE tool with intuitive graphical interface which allows you to build a clear and effective database structure visually, see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects.
Copy Schema for SQL Server 1.08.00
OmBelt Solutions
Copy Schema for SQL Server is an application for Microsoft SQL server that creates a copy for database objects definition: tables, views, triggers, indexes, primary and foreign keys, procedures, etc at the different database on the same or another server.
Copy Schema for SQL Server Professional 1.02.00
OmBelt Solutions
Copy Schema for SQL Server is an application for Microsoft SQL server that creates a copy for database objects definition: tables, views, triggers, indexes, primary and foreign keys, procedures, etc at the different database on the same or another server.
Audit Trail Wizard 1.2
Kerschkamp.nl
Audit Trail Wizard - Auditing Tool for SQL Server 2.
SqlSpec 6.5
ElsaSoft
SqlSpec is an application for generating SQL Database specs.
Softinabox Script Engine 0.3.0 Build 52 (Beta 3)
Softinabox
Softinabox Script Engine for Microsoft SQL Server 2000 is a powerful tool that enables you to document any existing database structure and/or data by generating one SQL script.