469,593 Members | 2,069 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,593 developers. It's quick & easy.

DB2 index related qusn

Hi

How to find out indexes on a table using SQl query....


some thing like :

show indexes on tab_name;

or

select indexes on tab_name;

thanks
Sumeet
Nov 18 '06 #1
1 3315
SELECT TBNAME, NAME FROM SYSIBM.SYSINDEXES
GROUP BY TBNAME, NAME;

Good luck.
Mondo Tofu
Dec 10 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Phil Latio | last post: by
3 posts views Thread by cmc | last post: by
29 posts views Thread by shmartonak | last post: by
2 posts views Thread by Thomas F.O'Connell | last post: by
5 posts views Thread by greenflame | last post: by
11 posts views Thread by Santosh | last post: by
2 posts views Thread by Abandoned | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.