Quality diagnostics tool for database model

Question

I´m looking for one tool capable to analyse an existing db model (an Oracle schema in my setup) building a report with quality metrics, potential causes of problems (circular constraints, for example), etc.

We have this kind of features for Java code using tools like PMD or checkstyle.

Does anyone know about some tool like this for database structures?

Answer 1

in quest software's TOAD there's a tool called code expert that does a lot of checks on stored code eg. views, stored procedures etc. maybee that can help