Execute: SELECT TBCREATOR, TBNAME, NAME, KEYSEQ FROM SYSIBM.SYSCOLUMNS

How to know the primary key of a table without defining the
primary key in the table?

Question Posted / mani

5 Answers
15344 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / mani

Execute:

SELECT TBCREATOR, TBNAME, NAME, KEYSEQ
FROM SYSIBM.SYSCOLUMNS
WHERE TBCREATOR = 'creater id'
AND TBNAME = 'table-name'
AND KEYSEQ > 0
ORDER BY KEYSEQ

a nonzero value for KEYSEQ indicates the place of a column in
the primary key.

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is db2 bind process?

1237

What is null indicator in cobol db2?

1066

What is the difference between cursor and select statement?

1101

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3581

How to find the maximum value in a column in the db2 database?

1082

Discuss about db2 bind?

1097

What is query_cache_limit?

970

Explain in detail about buffer manager and its functionalities?

1065

What is db2 plan table?

1049

what is a corelated subquerry?

1122

What is the difference between dbm cfg and db cfg file in db2 ?

1534

What is buffer pool and list some of them?

1028

What is page size in db2?

974

What is dpf in db2?

1109

How do I import data from excel to db2?

1072