Name: | IN_TRAY |
Schema: | USER |
Status: | NORMAL |
Create time: | 16.06.2006 |
Tablespace: | USERSPACE1 |
Index tablespace: | |
Long tablespace: | |
Base table schema: | |
Base table: | |
Rowtype schema: | |
Rowtype name: | |
Description: |
Name | Type | Length | Scale | Codepage | Identity | Nulls | Default | Description | |
|
RECEIVED | TIMESTAMP | 10 | 0 | 0 |
|
|
||
|
SOURCE | CHARACTER | 8 | 0 | 1251 |
|
|
||
|
SUBJECT | CHARACTER | 64 | 0 | 1251 |
|
|
||
|
NOTE_TEXT | VARCHAR | 3000 | 0 | 1251 |
|
|
Grantor | Grantee | Authorities | |
|
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 |
CREATE TABLE "USER "."IN_TRAY" (
"RECEIVED" TIMESTAMP ,
"SOURCE" CHAR(8) ,
"SUBJECT" CHAR(64) ,
"NOTE_TEXT" VARCHAR(3000) )
IN "USERSPACE1" ;
See Also
List of tables