SchemaCrawler 16.2.4
Database schema discovery and comprehension tool
Copyright (c) 2000-2020, Sualeh Fatehi <sualeh@hotmail.com>.

You can search for database schema objects using regular expressions,
and output the schema and data in a readable text format. You can find
potential schema design issues with lint. The output serves for
database documentation is designed to be diff-ed against other database
schemas. SchemaCrawler also generates schema diagrams.

System Information:
Windows 10 10.0
Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 1.8.0_191-b12

Available SchemaCrawler commands:
 brief          Shows basic schema information, for tables, views and routines,
                  columns, primary keys, and foreign keys
 count          Shows counts of rows in the tables
 details        Shows maximum possible detail of the schema, including
                  privileges, and details of privileges, triggers, and check
                  constraints
 dump           Shows data from all rows in the tables
 list           Shows a list of schema objects
 quickdump      Shows data from all rows in the tables, but row order is not
                  guaranteed - this can be used with a minimum info-level for
                  speed
 schema         Shows the commonly needed detail of the schema, including
                  details of tables, views and routines, columns, primary keys,
                  indexes, foreign keys, and triggers
 test-command   Test command which is not deployed with the release
 <query_name>   Shows results of query <query_name>, as specified in the
                  configuration properties file
 <query>        Shows results of SQL <query>
                The query itself can contain the variables ${table}, ${columns}
                  and ${tabletype}, or system properties referenced as
                  ${<system-property-name>}
                Queries without any variables are executed exactly once
                Queries with variables are executed once for each table, with
                  the variables substituted


Available SchemaCrawler database plugins:
 test-db        Test Database

