<< dblook examples | Using SignatureChecker >>

Specifying multiple tables

<< dblook examples | Using SignatureChecker >>

Derby Tools and Utilities Guide

java org.apache.derby.tools.dblook
-d 'jdbc:derby://localhost:1527/"C:\temp\sample";
user=someusername;password=somepassword' -z samp

Specifying a schema and a table within the database in the dblook command
You can specify that only the objects in the

sample

database that are associated with

the SAMP and the

My Table

table are written to the console. For example:

java org.apache.derby.tools.dblook -d jdbc:derby:sample -z samp -t "My
Table"

Specifying multiple tables in the dblook command
You can specify more than one table in the dblook command by separating the names
of the tables with a space. For example, for objects in the

sample

database that

are associated with either the

My Table

table or the

STAFF

table, use the following

command:

java org.apache.derby.tools.dblook -d jdbc:derby:sample -t "My Table"
staff

Writing DDL to a file without a statement delimiter
To write the DDL for all of the objects in

sample

database to the

myDB_DDL.sql

file

without a statement delimiter, you must omit the default semi-colon. You can append the
DDL to the output files if the files are already there. For example:

java org.apache.derby.tools.dblook -d jdbc:derby:sample
-o myDB_DDL.sql -td '' -append

Excluding views from the DDL
To write the DDL to the console for all of the objects in the

sample

database except for

views, use the following command:

java org.apache.derby.tools.dblook -d jdbc:derby:sample -noview