dblook options

The dblook utility options include the following.

-z schemaName

Specifies the schema to which the DDL should be restricted. Only objects with the specified schema are included in the DDL file.

-t tableOne tableTwo ...

Specifies the tables to which the DDL should be restricted. All tables with a name from this list will be included in the DDL file subject to -z limitations, as will the DDL for any keys, checks, or indexes on which the table definitions depend.

Additionally, if the statement text of any triggers or views includes a reference to any of the listed table names, the DDL for that trigger/view will also be generated, subject to -z limitations. If a table is not included in this list, then neither the table nor any of its keys, checks, or indexes will be included in the final DDL. If this option is not provided, all database objects will be generated, subject to -z limitations. Table names are separated by whitespace.

-td

Specifies a statement delimiter for SQL statements generated by dblook. If a statement delimiter option is not specified, the default is the semicolon (;). At the end of each DDL statement, the delimiter is printed, followed by a new line.

-o filename

Specifies the file where the generated DDL is written. If this file is not specified, it defaults to the console (that is, standard System.out).

-append

Prevents overwriting the DDL output (-o option, if specified) and dblook.log files. If this option is specified, and execution of the dblook command leads to the creation of files with names identical to existing files in the current directory, dblook will append to the existing files. If this option is not set, the existing files will be overwritten.

-verbose

Specifies that all errors and warnings (both SQL and internal to dblook) should be echoed to the console (through System.err), in addition to being printed to the dblook.log file. If this option is not set, the errors and warnings go only to the dblook.log file.

-noview

Specifies that CREATE VIEW statements should not be generated.

Related concepts
Using dblook
Generating the DDL for a database
Related reference
dblook examples