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

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

Answer Posted / kums

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

Is This Answer Correct ?

7 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2781

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2006

What is release/acquire in bind?

1058

How to execute stored procedure in db2 command editor?

986

What is db2 purescale?

945

What is schema in db2?

963

How to check table size in db2 sap?

978

What language is db2 written in?

982

How to check last update on table in db2?

1004

What is precompiler in db2?

960

What are types of indexes?

1001

How to view db2 table structure?

962

What is the reason behind not using select * in embedded sql programs?

1047

What is difference between alias and synonym in db2?

1072

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114