SchemaSpy

SchemaSpy analyzes schema metadata, letting you click through the hierarchy of your tables' parent/child relationships either via entity-relationship diagrams 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, Sybase, MaxDB, Firebird and Derby (JavaDB). 
 
You can browse a sample of its output at http://schemaspy.sourceforge.net/sample/  
 
Highlights of Release 4.0.0: 
 
- Foreign Key relationships can now be defined when a foreign key doesn't exist in the database. That and many additional metadata settings can now be specified via XML. 
 
- Compact view of relationships page now hides non-PK / non-indexed columns to reduce clutter and clarify the relationships. 
 
- jQuery is now used for DOM manipulation. 
 
- Added support for Derby (JavaDB) databases, both embedded and network. 
 
- Added support for SQL Server with jTDS driver. 
 
- Added support for SQL Server 2005. 
 
- Added support for MaxDB. 
 
- New -schemas option (similar to -all) for evaluating multiples with databases like MySQL where a database isn't composed of multiple schemas. 
 
- Significantly improved performance of generation of entity-relationship diagrams. 
 
- Better Unicode support resolve table name to URL mapping issues that show up with Japanese table names. 
 
- Now allows for customizable 'get row count' SQL as a way to improve performance. 
 
- New -font and -fontsize options. 
 
- Many additional bugs were fixed.