|
View previous topic :: View next topic
|
| Author |
Message |
dejunzhu
Active User
Joined: 08 May 2008
Posts: 390
Location: China
|
|
|
|
From SYSIBM.SYSINDEXES table, we can see the NUNMBER of columns that make up a specific index .
But I cannot find exactly the column names which make up the index.
Can anybody provide me a method to determine this?
Which catalog table should I query? |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Dejunzhu,
| Quote: |
| Can anybody provide me a method to determine this? |
QUERY
| Quote: |
| Which catalog table should I query? |
SYSKEYS
COLNAME in the SYSKEYS is what you are looking for, compare it by creator(index) & ixcreator(keys). order it by COLSEQ(keys).
To know more info about CATALOG tables read SQL REFERENCE catalog tables section.
Sushanth |
|
| Back to top |
|
|
dejunzhu
Active User
Joined: 08 May 2008
Posts: 390
Location: China
|
|
|
|
HI, Sushanth
Thank you very much! I got it. It really helps a lot. |
|
| Back to top |
|
|
|
|
