# 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.

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