# dblook

Use the `dblook` utility to view all or parts of the Data Definition Language (DDL) for a given database. To use the `dblook` utility, do one of the following:

- If you are relatively new to the Java programming language, follow the instructions in "Setting up your environment" in Getting Started with Java DB to set the `DERBY_HOME` and `JAVA_HOME` environment variables and to add `DERBY_HOME/bin` to your path. Then use the following command:

      dblook -d connectionURL [options]

- If you are a regular Java user but are new to Derby, set the `DERBY_HOME` environment variable, then use a `java` command to invoke the `derbyrun.jar` file (all on one line):

      (UNIX) java [options] -jar $DERBY_HOME/lib/derbyrun.jar dblook
                -d connectionURL [options]

      (Windows) java [options] -jar %DERBY_HOME%\lib\derbyrun.jar dblook
                -d connectionURL [options]

- If you are familiar with both the Java programming language and Derby, you have already set `DERBY_HOME`. Set your classpath to include the Derby jar files. Then use a `java` command to invoke the `dblook` class directly.

      java org.apache.derby.tools.dblook -d connectionURL [options]

- Using dblook
- dblook options
- Generating the DDL for a database
- dblook examples