how to know primary key of a table using qmf

mfibm · New User Joined: 12 Sep 2006 Posts: 13

how to know primary key of a table using qmf.....

let me know the full process..

tanks in advans

MFRASHEED · Active User Joined: 14 Jun 2005 Posts: 186 Location: USA

Try this query:

SELECT *
FROM SYSIBM.SYSCOLUMNS
WHERE KEYSEQ > 0 AND TBNAME = 'TABLE NAME'
ORDER BY TBNAME , TBCREATOR , KEYSEQ

If you use PLATINUM, it is much easier.

Enter Table name in Item Name and RI in DB2 Object then select PK = Primary Key Columns in next options screen.

Hope this helps.

mfibm · New User Joined: 12 Sep 2006 Posts: 13

tanks for ur time rasheed , let me try and check...

Likki

mfibm · New User Joined: 12 Sep 2006 Posts: 13

Hi rasheed......its fine .its working...........

tanks........
Likki