Search code examples
schemacrawler

How to extract basic descriptive stats on tables using schemacrawler

Is there a way to extract stat information such as

Below based on type of data type like string int etc. Count Mean Min distinct values Max Media STD null values Avg Top 10 values

Without using query on each table or something more efficient way without overloading the DB.

Also can we fetch few records for sample for each table when crawling.

Solution

  • SchemaCrawler can show you the output of arbitrary database queries. Please download the latest release, and work through the example that shows you how to get output from a database query.

    Sualeh Fatehi, SchemaCrawler