SchemaSpy analyzes schema metadata, letting you click through the hierarchy of your tables' parent/child relationships either graphically or through HTML tables. It works with just about any RDBMS given an appropriate JDBC driver. SchemaSpy also identifies several common schema anomalies.
SchemaSpy is available at http://schemaspy.sourceforge.net/ and currently supports Oracle, DB2, SQL Server, MySQL, PostgreSQL and Sybase.
You can browse a sample of its output at http://schemaspy.sourceforge.net/sample/
Highlights of Release 1.7.1:
- Added support for DB2's Net (Type 4) driver.
- Resolution of bug #1325650. Was having more problems with extracting information on Oracle indexes. Due to an Oracle driver bug (Oracle bug #2686037) I inverted how the selectIndexesSql gets evaluated and significantly optimized the SQL. Thanks to Andrea for helping to figure all of this out.
- Added details of the -cp option to the diagnostic messages when unable to load database drivers.
- Fixed some minor cosmetic problems.