ij

interactive JDBC script tool
0. set the classpath including derbyrun.jar, derby.jar and derbytool.jar
1. ij connect 'jdbc:derby:c:/testdb;create=true'  or 'jdbc:derby:/user/db' as myconnection1
2. show tables;
3. describe table_name
4. sql
5. run 'myscript.sql'

-dblook_find the  keys and etc info
dblook -d db_url -o myddb.sql -verbose
-sysinfo