|
DEPTNO |
CHARACTER |
3 |
0 |
1251 |
|
|
|
|
|
DEPTNAME |
VARCHAR |
29 |
0 |
1251 |
|
|
|
|
|
MGRNO |
CHARACTER |
6 |
0 |
1251 |
|
|
|
|
|
ADMRDEPT |
CHARACTER |
3 |
0 |
1251 |
|
|
|
|
|
LOCATION |
CHARACTER |
16 |
0 |
1251 |
|
|
|
|
Total: 5 column(s)
Total: 2 dependent object(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 "."DEPARTMENT" (
"DEPTNO" CHAR(3) NOT NULL ,
"DEPTNAME" VARCHAR(29) NOT NULL ,
"MGRNO" CHAR(6) ,
"ADMRDEPT" CHAR(3) NOT NULL ,
"LOCATION" CHAR(16) )
IN "USERSPACE1" ;
List of tables