Properties

Name: ACT 
Schema: USER 
Status: NORMAL 
Create time: 27.06.2006 
Tablespace: USERSPACE1 
Index tablespace:  
Long tablespace:  
Base table schema:  
Base table:  
Rowtype schema:  
Rowtype name:  
Description: This is the ACT table 

Columns

Name Type Length Scale Codepage Identity Nulls Default Description
  ACTNO  SMALLINT         
  ACTKWD  CHARACTER  1251         
  ACTDESC  VARCHAR  20  1251         
Total: 3 column(s)

Indexes

Name Unique rule Type Colnames Description
  USER.PK_ACT  PRIMARY  REGULAR  ACTNO   
  USER.XACT2  UNIQUE  REGULAR  ACTNO, ACTKWD   
  USER.XACT3  DUBLICATE  REGULAR  ACTNO, ACTKWD, ACTDESC   
Total: 3 index(s)

Constraints

Name Valid Text
  CC1151413049172    ACTNO >1000 
Total: 1 constraint(s)

Referencing tables

Table Foreign key Primary key
  USER.QQQ_STAFF  CC1152703301094  PK_ACT 
Total: 1 referencing table(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    "."ACT"  (
          "ACTNO" SMALLINT NOT NULL ,
          "ACTKWD" CHAR(6) NOT NULL ,
          "ACTDESC" VARCHAR(20) NOT NULL )  
         IN "USERSPACE1" ;

COMMENT ON TABLE "USER    "."ACT" IS 'This is the ACT table';


CREATE UNIQUE INDEX "USER    "."XACT2" ON "USER    "."ACT"
        ("ACTNO" ASC,
         "ACTKWD" ASC) ALLOW REVERSE SCANS;


CREATE INDEX "USER    "."XACT3" ON "USER    "."ACT"
        ("ACTNO" ASC,
         "ACTKWD" ASC,
         "ACTDESC" ASC) ALLOW REVERSE SCANS;


ALTER TABLE "USER    "."ACT"
    ADD CONSTRAINT "PK_ACT" PRIMARY KEY
        ("ACTNO");


ALTER TABLE "USER    "."ACT"
    ADD CONSTRAINT "CC1151413049172" CHECK
        (ACTNO >1000)
    ENFORCED
    ENABLE QUERY OPTIMIZATION;

See Also

List of tables