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.
|Tags||Database API Software Development Quality Assurance|
|Operating Systems||OS Independent|
Release Notes: This release adds more details about table constraints, including details of constrained columns.
Release Notes: The CheckConstraint class was renamed to TableConstraint, and provides more information about table constraints such as primary key, foreign key, and unique and check constraints.
Release Notes: InclusionRule is now an interface to allow for custom implementations.
Release Notes: This release supports all command-line options in the ant task. A bug with table restrictions is fixed.
Release Notes: PostgreSQL index metadata for tables is now retrieved correctly, despite PostgreSQL bugs #3480 and #6253. PostgreSQL and Apache Derby view definitions are also retrieved correctly, and index definitions are retrieved for PostgreSQL and Oracle.