Apache Darby

java org.apache.derby.tools.ij

CREATE

Database Name : test

ij> connect 'jdbc:derby:test;create=true' ;

Schema : IBM
Table : NameList

ij> CREATE TABLE IBM.NameList (
empNo INT NOT NULL,
empName VARCHAR(128)
);
0 rows inserted/updated/deleted

Table : PhoneList

ij> CREATE TABLE IBM.PhoneList (
empNo INT NOT NULL,
empPhoneNo VARCHAR(32)
);
0 rows inserted/updated/deleted

VIEW

java org.apache.derby.tools.dblook -d jdbc:derby:test

-- Timestamp: 2006-06-02 17:30:36.477
-- Source database is: test
-- Connection URL is: jdbc:derby:test
-- appendLogs: false

-- ----------------------------------------------
-- DDL Statements for schemas
-- ----------------------------------------------

CREATE SCHEMA "IBM";

-- ----------------------------------------------
-- DDL Statements for tables
-- ----------------------------------------------

CREATE TABLE "IBM"."NAMELIST" ("EMPNO" INTEGER NOT NULL, "EMPNAME" VARCHAR(128));

CREATE TABLE "IBM"."PHONELIST" ("EMPNO" INTEGER NOT NULL, "EMPPHONENO" VARCHAR(32));