1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
|
CREATE TABLE "PR1"."TABLE1"
(
VALEUR char(2) NOT NULL,
COL2 smallint NOT NULL,
COL3 smallint NOT NULL,
COL4 smallint NOT NULL,
COL5 char(10) NOT NULL,
COL6 date NOT NULL,
COL7 char(10) NOT NULL,
CODE smallint NOT NULL,
COL9 char(80) NOT NULL,
COL10 char(1) NOT NULL,
COL11 date NOT NULL,
COL12 char(8) NOT NULL,
COL13 timestamp NOT NULL,
COL14 char(8) NOT NULL,
COL15char(8) NOT NULL,
CONSTRAINT null PRIMARY KEY (VALEUR ,COL2 ,COL3 ,COL4 ,COL5 ,COL6 ,COL7 ,CODE)
)
;
CREATE UNIQUE INDEX TABLE1 ON "PR1"."TABLE1"
(
VALEUR ,
COL2 ,
COL3 ,
COL4 ,
COL5 ,
COL6 ,
COL7 ,
CODE
)
; |
Partager