Properties

Name:	IBMSNAP_CAPTRACE
Schema:	ASN
Status:	NORMAL
Create time:	01.07.2006
Tablespace:	TSASNCA
Index tablespace:
Long tablespace:
Base table schema:
Base table:
Rowtype schema:
Rowtype name:
Description:

Columns

	Name	Type	Length	Scale	Codepage	Identity	Nulls	Default	Description
	OPERATION	CHARACTER	8	0	1251
	TRACE_TIME	TIMESTAMP	10	0	0
	DESCRIPTION	VARCHAR	1024	0	1251

Total: 3 column(s)

Indexes

	Name	Unique rule	Type	Colnames	Description
	ASN.IBMSNAP_CAPTRACEX	DUBLICATE	REGULAR	TRACE_TIME

Total: 1 index(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 "ASN     "."IBMSNAP_CAPTRACE"  (
          "OPERATION" CHAR(8) NOT NULL ,
          "TRACE_TIME" TIMESTAMP NOT NULL ,
          "DESCRIPTION" VARCHAR(1024) NOT NULL )  
         IN "TSASNCA" ;

CREATE INDEX "ASN     "."IBMSNAP_CAPTRACEX" ON "ASN     "."IBMSNAP_CAPTRACE"
        ("TRACE_TIME" ASC);

See Also

List of tables