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

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

Is db2 a mainframe database?

568


What is a Foreign Key?

658


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

628


What is a db2 cursor?

626


What is performance tuning db2?

620






How connect db2 database to datastage?

765


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1820


Is db2 free?

684


What are db2 tables?

649


What is null indicator in cobol db2?

586


What does db2 blu stand for?

662


Is db2 relational database?

574


What is sqlca?

625


What is package in db2 mainframe?

559


What is meant by explain?

662