How to know the columns that are part of an index

deepak.vl · New User Joined: 17 Feb 2007 Posts: 38 Location: Hyderabad

Hi All,
I want to know all the columns of a table which are part of a particular index. How do I know them from SYSIBM tables? I understand that SYSIBM.SYSINDEXES has information abt indexes on a particular table. But it will not give the list of columns. Please help.

Thanks a lot.

Prajesh_v_p · Active User Joined: 24 May 2006 Posts: 133 Location: India

You could use the sysibm.syskeys table once u know the index name, to get the clumns

Thanks,
Prajesh

deepak.vl · New User Joined: 17 Feb 2007 Posts: 38 Location: Hyderabad

thanks a lot man

. I got wat I needed.