|
View previous topic :: View next topic
|
| Author |
Message |
prashu
New User
.jpg)
Joined: 12 Jun 2005
Posts: 7
Location: hyderabad
|
|
|
|
| 1. i have a table employee.it contains coloumns like empname,empid,empaddress,empsal.then what is the query to findout index of the table. |
|
| Back to top |
|
 |
MGIndaco
Active User
Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy
|
|
|
|
Try to search in system tables with
| Code: |
SELECT * FROM SYSIBM.SYSINDEXES
WHERE TBNAME = 'yourtable' |
To retrieve the name of your indexes and after, to know the key of the indexes(and its order or sequence) use this:
| Code: |
SELECT * FROM SYSIBM.SYSKEYS
WHERE IXNAME = 'yourindex' |
I hope in this little help. |
|
| Back to top |
|
|
|
|
