Name: | IBMSNAP_CAPSCHEMAS |
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 | |
|
CAP_SCHEMA_NAME | VARCHAR | 30 | 0 | 1251 |
|
|
Name | Unique rule | Type | Colnames | Description | |
|
ASN.IBMSNAP_CAPSCHEMAX | UNIQUE | REGULAR | CAP_SCHEMA_NAME |
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_CAPSCHEMAS" (
"CAP_SCHEMA_NAME" VARCHAR(30) )
IN "TSASNCA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_CAPSCHEMAX" ON "ASN "."IBMSNAP_CAPSCHEMAS"
("CAP_SCHEMA_NAME" ASC);
See Also
List of tables