|
ACTNO |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
ACTKWD |
CHARACTER |
6 |
0 |
1251 |
|
|
|
|
|
ACTDESC |
VARCHAR |
20 |
0 |
1251 |
|
|
|
|
Total: 3 column(s)
Total: 3 index(s)
Total: 1 constraint(s)
Total: 1 referencing table(s)
|
SYSIBM |
USER |
CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
Total: 1 autherisation(s)
CREATE TABLE "USER "."ACT" (
"ACTNO" SMALLINT NOT NULL ,
"ACTKWD" CHAR(6) NOT NULL ,
"ACTDESC" VARCHAR(20) NOT NULL )
IN "USERSPACE1" ;
COMMENT ON TABLE "USER "."ACT" IS 'This is the ACT table';
CREATE UNIQUE INDEX "USER "."XACT2" ON "USER "."ACT"
("ACTNO" ASC,
"ACTKWD" ASC) ALLOW REVERSE SCANS;
CREATE INDEX "USER "."XACT3" ON "USER "."ACT"
("ACTNO" ASC,
"ACTKWD" ASC,
"ACTDESC" ASC) ALLOW REVERSE SCANS;
ALTER TABLE "USER "."ACT"
ADD CONSTRAINT "PK_ACT" PRIMARY KEY
("ACTNO");
ALTER TABLE "USER "."ACT"
ADD CONSTRAINT "CC1151413049172" CHECK
(ACTNO >1000)
ENFORCED
ENABLE QUERY OPTIMIZATION;
List of tables