How to determine Unique Index column name for a DB2 table?

[Rakhee Aggarwal]

Hi,

Can you please help me that how to find out the unique index column name for a table? Can we know it from some SYSIBM table? Please guide.

[zprogrammer]

Check this link

[Rakhee Aggarwal]

Thanks Pandora-Box. The links gives the details about sysibm.sysindexs but can I write an SQL to retrive the columns for the indexes for a table?

[Chandan Yadav]

Hi Rakhee,

Please use below query to find unique index of a table

Code: Select all

SELECT NAME,COLNAME                      
FROM SYSIBM.SYSINDEXES,SYSIBM.SYSKEYS    
WHERE TBNAME='table name' 
AND TBCREATOR='creator'                  
AND UNIQUERULE ='U'                      
AND NAME= IXNAME                        
AND IXCREATOR=CREATOR 

Regards,
Chandan

[Rakhee Aggarwal]

Thank you Chandan, this has helped.