Properties

Name: XACT2 
Schema: USER 
Table schema: USER 
Table: ACT 
Unique rule: UNIQUE 
Type: REGULAR 
Create time: 27.06.2006 
Tablespace: USERSPACE1 
Description:  

Columns

Colname Order
  ACTNO  ASCENDING 
  ACTKWD  ASCENDING 
Total: 2 column(s)

Autherisations

Grantor Grantee Authorities
  SYSIBM  USER  CONTROL=HELD 
Total: 1 autherisation(s)

SQL

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

See Also

List of indexes