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
Name the various locking levels available?
What is coalesce in db2?
What are the rules for db2 programming?
What is view db2?
What is plan in cobol db2?
What is the difference between bind and rebind in db2?
What is sqlca’s maximum length?
How to find the maximum value in a column in the db2 database?
What are the contents of dclgen?
What is ibm db2 used for?
What is schema in db2?
How does cobol compile db2 program?
How do I delete a column in db2?
What is the latest version of ibm db2?
How is a typical db2 batch pgm executed?