Properties

Name: IBMSNAP_SUBS_MEMBX 
Schema: ASN 
Table schema: ASN 
Table: IBMSNAP_SUBS_MEMBR 
Unique rule: UNIQUE 
Type: REGULAR 
Create time: 01.07.2006 
Tablespace: TSASNAA 
Description:  

Columns

Colname Order
  APPLY_QUAL  ASCENDING 
  SET_NAME  ASCENDING 
  WHOS_ON_FIRST  ASCENDING 
  SOURCE_OWNER  ASCENDING 
  SOURCE_TABLE  ASCENDING 
  SOURCE_VIEW_QUAL  ASCENDING 
  TARGET_OWNER  ASCENDING 
  TARGET_TABLE  ASCENDING 
Total: 8 column(s)

Autherisations

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

SQL

CREATE UNIQUE INDEX "ASN     "."IBMSNAP_SUBS_MEMBX" ON "ASN     "."IBMSNAP_SUBS_MEMBR"
        ("APPLY_QUAL" ASC,
         "SET_NAME" ASC,
         "WHOS_ON_FIRST" ASC,
         "SOURCE_OWNER" ASC,
         "SOURCE_TABLE" ASC,
         "SOURCE_VIEW_QUAL" ASC,
         "TARGET_OWNER" ASC,
         "TARGET_TABLE" ASC);

See Also

List of indexes