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: |
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 |
|
|
Name | Unique rule | Type | Colnames | Description | |
|
ASN.IBMSNAP_CAPTRACEX | DUBLICATE | REGULAR | TRACE_TIME |
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 "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