MegaAnomaly

Basic tool to find tables without primary key and isolated tables.

Inspiration

Find inconsistency or poor quality in database design.

Features

1. quantity of isolated tables and quantity of tables without primary key per schema,
2. the percentage of isolated tables and tables without primary key for each schema,
3. the average percentage of isolated tables and tables without primary key of all schemes

Note: Better tools are SchemaCrawler or SpySchema.

Requirements and Limitations

This application is build:

• Using Eclipse
• Connection only to Oracle database.
• Written in Java