|
EMPNO |
CHARACTER |
6 |
0 |
1251 |
|
|
|
|
|
RESUME_FORMAT |
VARCHAR |
10 |
0 |
1251 |
|
|
|
|
|
RESUME |
CLOB |
5120 |
0 |
1251 |
|
|
|
|
Total: 3 column(s)
Total: 1 index(s)
Total: 1 referenced 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 "."EMP_RESUME" (
"EMPNO" CHAR(6) NOT NULL ,
"RESUME_FORMAT" VARCHAR(10) NOT NULL ,
"RESUME" CLOB(5120) LOGGED NOT COMPACT )
IN "USERSPACE1" ;
ALTER TABLE "USER "."EMP_RESUME"
ADD PRIMARY KEY
("EMPNO",
"RESUME_FORMAT");
ALTER TABLE "USER "."EMP_RESUME"
ADD CONSTRAINT "CC1151778995891" FOREIGN KEY
("EMPNO")
REFERENCES "USER "."EMPLOYEE"
("EMPNO")
ON DELETE RESTRICT
ON UPDATE RESTRICT
ENFORCED
ENABLE QUERY OPTIMIZATION;
List of tables