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

Answer Posted / ambika

u can use sysibm.syskeys to view the primary key of a
particular table provided if u have declared any attribute
as NOT NULL. if there are multiple columns of such kind u
the above procedure wont help.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is ibm db2 free?

573


What is db2 connect?

603


What do you mean by cursor?

582


How is a typical db2 batch pgm executed?

640


What is db2 look?

574






What is alias in db2?

566


What is view db2?

622


Mention the definition of cobol in varchar field.

688


What are host variables in db2?

624


How to retrieve rows from a db2 table in embedded sql?

723


What are db2 objects?

639


Give a brief description of db2 isolation levels?

599


Is db2 a mainframe database?

567


What is plan in cobol db2?

589


Explain about rct.

646