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
15509 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

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1133

What os does db2 run on?

1047

Can we delete records from view?

1022

What is ibm db2 database?

1066

What is image copy in db2?

1071

Can we insert update delete in view?

1028

What does runstats do in db2?

1184

Explain the contention situations caused by locks?

1145

How is deadlock resolved?

1203

What is declare cursor?

1169

When do you specify the isolation level?

1072

Explain in brief how does db2 determine what lock-size to use?

1090

What is bind package and plan in db2?

1108

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3205

Which components manage deadlocks in db2?

1121