you could use SYSIBM.SYSINDEXES table to know more about the table index.

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

Question Posted / kums

Answer Posted / kums

you could use SYSIBM.SYSINDEXES table to know more about
the table index.

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Mention some fields that are a part of sqlca.

1043

What is package in cobol db2?

1121

How to find the number of rows in db2 tables?

1073

What is the clustering index in the db2 database?

1005

What do you mean by commit and rollback?

1049

can we view the access paths created by dbrm ? how ? thx

7104

How do I add a column to an existing table in db2?

1032

What does db2 blu stand for?

1171

What db2 400?

1203

Explain about open switch business continuity software?

1140

What is db2?

1186

What's The Percentage Free Space ?

1228

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

1540

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1163

What is bind package and plan in db2?

1058