|
DEPTNUMB |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
DEPTNAME |
VARCHAR |
14 |
0 |
1251 |
|
|
|
|
|
MANAGER |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
DIVISION |
VARCHAR |
10 |
0 |
1251 |
|
|
|
|
|
LOCATION |
VARCHAR |
13 |
0 |
1251 |
|
|
|
|
Total: 5 column(s)
Total: 1 index(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 "."ORG" (
"DEPTNUMB" SMALLINT NOT NULL ,
"DEPTNAME" VARCHAR(14) ,
"MANAGER" SMALLINT ,
"DIVISION" VARCHAR(10) ,
"LOCATION" VARCHAR(13) )
IN "USERSPACE1" ;
ALTER TABLE "USER "."ORG"
ADD CONSTRAINT "CC1151755924953" PRIMARY KEY
("DEPTNUMB");
List of tables