Menu

SchemaSpy 3.1.0 released

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.1.0:

- The Columns page is now sortable by column, table, type, size, nullability, auto increment, default value, children or parents.

- Added a new option (-desc) to provide a description of the schema that is displayed on the non-detail pages.

- Added -notablecomments option for databases like MySQL that stuff unrelated data where comments belong.

- Many bugs were fixed, including support for Oracle 10g's recycle bin.

Posted by John Currier 2006-10-05

Log in to post a comment.