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

What is the maximum size of a char data type in db2?

1010

What is the advantage in De-normalizing tables in DB2?

1168

What are concurrency issues?

1094

What is node in db2?

1042

Why do we bind in db2?

1207

What is the use of commit in db2?

1073

How can the duplicate values be eliminated from db2 select?

1100

How can you quickly find out the # of rows updated after an update statement?

1036

What are iseries servers?

1071

What is null value in db2?

1019

What are the contents of dclgen?

1103

Why select is not preferred in embedded sql programs?

1298

What is the use of db2 optimizer?

1110

What is cobol db2?

993

What do you mean by between and in? Is between inclusive of specified range values?

1088