SchemaCrawler is a Java API which makes working with database metadata as easy as working with ordinary Java objects. It is also a database schema discovery and comprehension and schema documentation tool. You can search for database schema objects using regular expressions, output the schema and data in a readable text format, and find potential design issues with lint . The output is designed to be diff-ed against other database schemas. SchemaCrawler supports almost any database which has a JDBC driver, but for convenience is bundled with drivers for some commonly-used RDBMS systems. SchemaCrawler works with any operating system which supports Java.

SchemaCrawler now supports J2SE 7 only, since previous Java versions are deprecated. A new commandline option, modeled after the analogous grep option -only-matching, shows only matching tables, and does not show foreign keys which reference other non-matching tables. A new option "schemacrawler.encoding.input" can be set in the SchemaCrawler properties file to specify the input encoding format for script files and templates. The command-line option -table_types is renamed to -tabletypes

SchemaCrawler – Freecode

SchemaCrawler 10.1-0426_schemacrawler_10.1.png