How to find the primary key of a particular table?

[Aniket sonmale]

hi,

i am working on db2.
how can i check for a particular table,the primary key of that table.
for eg. in table REGISTRATION their are around 20 columns. how to check which is the primary key of that table

[deepak n]

Try the following query

SELECT sc.name
FROM SYSIBM.SYSCOLUM NS SC
WHERE SC.TBNAME = 'REGISTRATION'
AND sc.identity ='N'
AND sc.tbcreator=sc hemaname
AND sc.keyseq=1

[Aniket sonmale]

It worked.

Thank you deepak