Properties

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:  

Columns

Name Type Length Scale Codepage Identity Nulls Default Description
  RECEIVED  TIMESTAMP  10         
  SOURCE  CHARACTER  1251         
  SUBJECT  CHARACTER  64  1251         
  NOTE_TEXT  VARCHAR  3000  1251         
Total: 4 column(s)

Autherisations

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 
Total: 1 autherisation(s)

SQL

CREATE TABLE "USER    "."IN_TRAY"  (
          "RECEIVED" TIMESTAMP ,
          "SOURCE" CHAR(8) ,
          "SUBJECT" CHAR(64) ,
          "NOTE_TEXT" VARCHAR(3000) )  
         IN "USERSPACE1" ;

See Also

List of tables