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
How do I delete a column in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How do I add a column to an existing table in db2?
What is a page in db2?
What is collection in db2 bind?
What is the result of open cursor statement?
How to find primary key of a table in db2?
Can there be more than one cursor open for any program?
How do you find the maximum value in a column in db2?
Are view updateable?
What is a db2 cursor?
What are packages in db2?
What is image copy in db2?
What is syscat in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?