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	0	0
	SOURCE	CHARACTER	8	0	1251
	SUBJECT	CHARACTER	64	0	1251
	NOTE_TEXT	VARCHAR	3000	0	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