4. dblookユーティリティ

sampleデータベースのデータ定義言語(DDL)を表示する。

(1)事前準備

demo\databasesディレクトリに移動し、環境変数を設定するバッチファイルを起動する

cd C:\opt\Cloudscape_10.1\demo\databases
C:\opt\Cloudscape_10.1\demo\databases>C:\opt\Cloudscape_10.1\frameworks\embedded\bin\setEmbeddedCP.bat

(2)dblookユーティリティでDDL表示

sampleファイルのDDLを表示した。

C:\opt\Cloudscape_10.1\demo\databases>java org.apache.derby.tools.dblook -d jdbc:derby:sample
 -- ============================
 
 -- This file was created using Derby's dblook utility.
 -- Timestamp: 2005-09-02 20:41:53.183
 -- Source database is: sample
 -- Connection URL is: jdbc:derby:sample
 -- appendLogs: false
 
 -- ----------------------------------------------
 -- DDL Statements for schemas
 -- ----------------------------------------------
 
CREATE SCHEMA "SAMP";
 
 -- ----------------------------------------------
 -- DDL Statements for tables
 -- ----------------------------------------------

CREATE TABLE "SAMP"."EMPLOYEE" ("EMPNO" CHAR(6) NOT NULL, "FIRSTNME" VARCHAR(12) NOT NULL, "MIDINIT" CHAR(1) NOT NULL, "LASTNAME" VARCHAR(15) NOT NULL, "WORKDEPT" CHAR(3), "PHONENO" CHAR(4), "HIREDATE" DATE, "JOB" CHAR(8), "EDLEVEL" SMALLINT NOT NULL, "SEX" CHAR(1), "BIRTHDATE" DATE, "SALARY" DECIMAL(9,2), "BONUS" DECIMAL(9,2), "COMM" DECIMAL(9,2));

CREATE TABLE "SAMP"."ORG" ("DEPTNUMB" SMALLINT NOT NULL, "DEPTNAME" VARCHAR(14), "MANAGER" SMALLINT, "DIVISION" VARCHAR(10), "LOCATION" VARCHAR(13));

CREATE TABLE "SAMP"."DEPARTMENT" ("DEPTNO" CHAR(3) NOT NULL, "DEPTNAME" VARCHAR(29) NOT NULL, "MGRNO" CHAR(6), "ADMRDEPT" CHAR(3) NOT NULL, "LOCATION" CHAR(16));

CREATE TABLE "SAMP"."CL_SCHED" ("CLASS_CODE" CHAR(7), "DAY" SMALLINT, "STARTING" TIME, "ENDING" TIME);

CREATE TABLE "SAMP"."SALES" ("SALES_DATE" DATE, "SALES_PERSON" VARCHAR(15), "REGION" VARCHAR(15), "SALES" INTEGER);

CREATE TABLE "SAMP"."EMP_PHOTO" ("EMPNO" CHAR(6) NOT NULL, "PHOTO_FORMAT" VARCHAR(10) NOT NULL, "PICTURE" BLOB(102400));

CREATE TABLE "SAMP"."PROJECT" ("PROJNO" CHAR(6) NOT NULL, "PROJNAME" VARCHAR(24) NOT NULL, "DEPTNO" CHAR(3) NOT NULL, "RESPEMP" CHAR(6) NOT NULL, "PRSTAFF" DECIMAL(5,2), "PRSTDATE" DATE, "PRENDATE" DATE, "MAJPROJ" CHAR(6));

CREATE TABLE "SAMP"."EMP_ACT" ("EMPNO" CHAR(6) NOT NULL, "PROJNO" CHAR(6) NOT NULL, "ACTNO" SMALLINT NOT NULL, "EMPTIME" DECIMAL(5,2), "EMSTDATE" DATE, "EMENDATE" DATE);

CREATE TABLE "SAMP"."STAFF" ("ID" SMALLINT NOT NULL, "NAME" VARCHAR(9), "DEPT" SMALLINT, "JOB" CHAR(5), "YEARS" SMALLINT, "SALARY" DECIMAL(7,2), "COMM" DECIMAL(7,2));

CREATE TABLE "SAMP"."IN_TRAY" ("RECEIVED" TIMESTAMP, "SOURCE" CHAR(8), "SUBJECT" CHAR(64), "NOTE_TEXT" VARCHAR(3000));

CREATE TABLE "SAMP"."EMP_RESUME" ("EMPNO" CHAR(6) NOT NULL, "RESUME_FORMAT" VARCHAR(10) NOT NULL, "RESUME" CLOB(5120));

 -- ----------------------------------------------
 -- DDL Statements for keys
 -- ----------------------------------------------

 -- primary/unique
ALTER TABLE "SAMP"."EMP_RESUME" ADD CONSTRAINT "SQL050809100722360" PRIMARY KEY ("EMPNO", "RESUME_FORMAT");

ALTER TABLE "SAMP"."EMP_PHOTO" ADD CONSTRAINT "SQL050809100723140" PRIMARY KEY ("EMPNO", "PHOTO_FORMAT");