 | SchemaSpySchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database. |
| Download | |
SchemaSpy Ranking & Summary
Advertisement
SchemaSpy Tags
SchemaSpy Description
SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database. SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships.The browsing through relationships can occur though HTML links and/or though the graphical representation of the relationships. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints. SchemaSpy is free software, distributed under the terms of the Lesser GNU Public License. Your donations are, however, greatly appreciated. SchemaSpy uses the dot executable from Graphviz to generate graphical representations of the table/view relationships. This was initially added for people who see things visually.Now the graphical representation of relationships is a fundamental feature of the tool. Graphvis is not required to view the output generated by SchemaSpy, but the dot program should be in your PATH (not CLASSPATH) when running SchemaSpy or none of the graphs will be generated. Some Linux users have experienced problems with dot version 2.6. Version 2.6 (or higher) is preferred, but if it doesn't work then try 2.2.1. Note that SchemaSpy takes advantage of some dot 2.6+ features so graphs won't be as well formed when using 2.2.1. SchemaSpy uses JDBC's database metadata extraction services to gather the majority of its information, but has to make vendor-specific SQL queries to gather some information such as the SQL associated with a view and the details of check constraints.The differences between vendors have been isolated to configuration files and are extremely limited. Almost all of the vendor-specific SQL is optional. What's New in This Release: · Resolved an exception when the extends directive has trailing spaces. · Resolved a problem where DB2 views showed a null ID on the tables index page.
SchemaSpy Related Software