Index: ASN.IBMSNAP_PRUNCNTLX
Index: ASN.IBMSNAP_PRUNCNTLX
| Name: | IBMSNAP_PRUNCNTLX |
| Schema: | ASN |
| Table schema: | ASN |
| Table: | IBMSNAP_PRUNCNTL |
| Unique rule: | UNIQUE |
| Type: | REGULAR |
| Create time: | 01.07.2006 |
| Tablespace: | TSASNCA |
| Description: |
| Colname | Order | |
|
|
SOURCE_OWNER | ASCENDING |
|
|
SOURCE_TABLE | ASCENDING |
|
|
SOURCE_VIEW_QUAL | ASCENDING |
|
|
APPLY_QUAL | ASCENDING |
|
|
SET_NAME | ASCENDING |
|
|
TARGET_SERVER | ASCENDING |
|
|
TARGET_TABLE | ASCENDING |
|
|
TARGET_OWNER | ASCENDING |
| Grantor | Grantee | Authorities | |
|
|
SYSIBM | USER | CONTROL=HELD |
CREATE UNIQUE INDEX "ASN "."IBMSNAP_PRUNCNTLX" ON "ASN "."IBMSNAP_PRUNCNTL"
("SOURCE_OWNER" ASC,
"SOURCE_TABLE" ASC,
"SOURCE_VIEW_QUAL" ASC,
"APPLY_QUAL" ASC,
"SET_NAME" ASC,
"TARGET_SERVER" ASC,
"TARGET_TABLE" ASC,
"TARGET_OWNER" ASC);
See Also
List of indexes