org.apache.openjpa.jdbc.schema
Class SchemaTool

The SchemaTool is used to manage the database schema. Note that the
tool never adds or drops unique constraints from existing tables, because
JDBC DatabaseMetaData does not include information on these
constraints.

-properties/-p <properties file or resource>: The
path or resource name of a OpenJPA properties file containing
information such as the license key and connection data as
outlined in JDBCConfiguration. Optional.

-<property name> <property value>: All bean
properties of the OpenJPA JDBCConfiguration can be set by
using their names and supplying a value. For example:
-licenseKey adslfja83r3lkadf

-ignoreErrors/-i <true/t | false/f>: If false, an
exception will will be thrown if the tool encounters any database
exceptions; defaults to false.

-file/-f <stdout | output file or resource>: Use this
option to write a SQL script for the planned schema modifications,
rather than committing them to the database. This option also
applies to the export and reflect actions.

-openjpaTables/-kt <true/t | false/f>: Under the
reflect action, whether to reflect on tables with
the name OPENJPA_*. Under other actions, whether to
drop such tables. Defaults to false.

-dropTables/-dt <true/t | false/f>: Set this option to
true to drop tables that appear to be unused during
retain and refresh actions. Defaults to
true.

-dropSequences/-dsq <true/t | false/f>: Set this option
to true to drop sequences that appear to be unused during
retain and refresh actions. Defaults to
true.