How to identify the primary key in a table?

chandu_605k · Posted: Tue Jul 25, 2006 12:03 pm

Hi Friendz,
This is reagrding DB2. I know the table name is X. But i don't know what is the primary key defined in this table : X. Could you please let me know, if you know how to find this?

Thanks & Regards
CSR

anamikak · New User Joined: 10 May 2006 Posts: 64 Location: Singapore

You can query the catalog tables for this-

Try out this query:

SELECT NAME,UNIQUERULE from SYSIBM.SYSINDEXSES
where TBNAME= 'your table name' and UNIQUERULE = 'P';

neelesht · Posted: Fri Jul 28, 2006 12:37 pm

Hi Anamika,

what does UNIQUERULE = 'P' mean here ?

Thanks.

chandu_605k · Posted: Fri Jul 28, 2006 12:44 pm

Hi Anamika,
Thanks for sending a quick reply. Its working. Thanks Once again.

Hi Neel(Simply),
'P' means Primary key.
Please correct me if i am wrong.

Thanks & Regards
CSR

neelesht · Posted: Fri Jul 28, 2006 12:46 pm

Thanks CSR.......so sorry for such a silly qns......

Thanks Anamika.

Thanks.