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