SchemaCrawler - Introduction
SchemaCrawler is a free database schema discovery and comprehension tool. SchemaCrawler has a good mix of useful features for data governance. You can search for database schema objects using regular expressions, and output the schema and data in a readable text format. The output serves for database documentation, and is designed to be diff-ed against other database schemas. SchemaCrawler also generates schema diagrams. You can execute scripts in any standard scripting language against your database. You can find potential schema design issues with lint.
SchemaCrawler - Examples
Step 1 - Download SchemaCrawler
This scenario shows you how to download SchemaCrawler, and run the examples.
Download the SchemaCrawler Release
Download the latest SchemaCrawler release, by running:
wget -N -q --show-progress https://github.com/schemacrawler/SchemaCrawler/releases/download/v16.15.10/schemacrawler-16.15.10-distribution.zip
and unzip it by running:
unzip -q -u schemacrawler-16.15.10-distribution.zip