Properties

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:

Columns

	Name	Type	Length	Scale	Codepage	Identity	Nulls	Default	Description
	CAP_SCHEMA_NAME	VARCHAR	30	0	1251

Total: 1 column(s)

Indexes

	Name	Unique rule	Type	Colnames	Description
	ASN.IBMSNAP_CAPSCHEMAX	UNIQUE	REGULAR	CAP_SCHEMA_NAME

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_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