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
Explain packages.
What is the difference between drop table and delete table?
Who uses db2?
What is null in db2?
How do you find the maximum value in a column in db2?
What is the difference between bind and rebind in db2?
What is meant by dclgen?
What is temporal table in db2?
Is schema the same as database?
What is bind in db2?
How to check table size in db2 sap?
What is db2? Explain.
Why do we bind in db2?
How do you stop a db2 database in linux?
What is a trigger in the db2 database?