Find the Primary key of the table with sysibm command

Asokrani · Posted: Wed Jan 23, 2008 12:02 am

Hi

How can i find the Primary key of the table with sysibm command

Craq Giegerich · Posted: Wed Jan 23, 2008 12:40 am

the_gautam · Posted: Wed Jan 23, 2008 3:55 pm

SELECT NAME FROM SYSIBM.SYSCOLUMNS WHERE TBCREATOR = <TABLE CREATOR NAME> AND TBNAME = <TABLE NAME> AND KEYSEQ > 0;

the_gautam · Posted: Wed Jan 23, 2008 4:01 pm

SELECT A.COLNAME, A.COLSEQ, A.ORDERING FROM SYSIBM.SYSKEYS A, SYSIBM.SYSINDEXES B WHERE A.IXNAME=B.NAME AND A.IXCREATOR=B.CREATOR AND B.TBNAME=<TABLE NAME> AND B.TBCREATOR=<TABLE CREATOR> AND B.UNIQUERULE='P';

OR,

SELECT NAME FROM SYSIBM.SYSCOLUMNS WHERE TBCREATOR = <TABLE CREATOR NAME> AND TBNAME = <TABLE NAME> AND KEYSEQ > 0;