Start the Derby Interactive SQL Tool

java -cp "c:\jdk1.6.0_01\db\lib\derby.jar;c:\jdk1.6.0_01\db\lib\derbytools.jar" org.apache.derby.tools.ij​ij version 10.2 ​ij>

Next: Page 2
Back Up: Menu

Show available commands

​ij> help;

Next: Page 3
Prev: Page 1
Back Up: Menu

Connection commands

Create a database:

​ij> connect 'jdbc:derby:C:/Documents and Settings/username/.derby/dbname;create=true';

To drop a database, simply remove the directory:

rmdir /s "%USERPROFILE%\.derby\dbname"

Connect to an existing database:

​ij> connect 'jdbc:derby:C:/Documents and Settings/username/.derby/dbname';​ij> connect 'jdbc:derby:C:/Documents and Settings/username/.derby/dbname' as connname;

The default connection name is "CONNECTIONn", where n is numeric.

Show information about established connections:

​ij> show connections;

Switch to a different connection:

​ij> set connname;

Disconnect a connection:

​ij> disconnect current;​ij> disconnect connname;

Next: Page 4
Prev: Page 2
Back Up: Menu

Schema commands

Create a schema

​ij> create schema schemaname;​ij> create schema "SchemaName";

Show available schemas

​ij> show schemas;

Change schemas

​ij> set current sqlid schemaname;​ij> set current sqlid = "SchemaName";

Next: Page 5
Prev: Page 3
Back Up: Menu

Commands for Tables in Database

Show tables in schema

​ij> show tables in sys;​ij> show tables in schemaname;​ij> show tables in "SchemaName";

Similarly, "views", "procedures" "synonyms" and "indexes" can also be displayed.

Show indexes for a table

​ij> show indexes from tablename;​ij> show indexes from schemaname.tablename;​ij> show indexes from "SchemaName"."TableName";

Prev: Page 4
Back Up: Menu