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, Firebird, PostgreSQL, HSQLDB, Informix and Sybase.
You can browse a sample of its output at http://schemaspy.sourceforge.net/sample/
Highlights of Release 3.0.0:
- SchemaSpy now generates an XML representation of the database's schema.
- New -all option analyzes all schemas in the database with one command.
- Now displays database table and row comments.
- You can now specify a subset of tables/views to include in the analysis with the new -i <tableNamesRegex> option.