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
15120 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 plan in cobol db2?

1055

is it compulsory commitment control in journal?

2411

What is db2 catalog database?

982

What is a bind in db2?

977

Which component is responsible for processing sql statements and selecting access paths?

1068

How does a cursor work?

923

Highlight all the advantages that are attached to a package.

1070

Describe major components of db2?

1039

What is the difference between plan and package in db2?

1034

List out the buffer pools in db2

1017

Define db2 and its databases?

995

What are foreign keys in db2?

1031

Are views updateable?

1065

How is a typical db2 batch pgm executed?

1106

What is the use of reorg in db2?

1021