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

Explain packages.

903


What is the difference between drop table and delete table?

831


Who uses db2?

793


What is null in db2?

778


How do you find the maximum value in a column in db2?

866


What is the difference between bind and rebind in db2?

1212


What is meant by dclgen?

887


What is temporal table in db2?

830


Is schema the same as database?

857


What is bind in db2?

811


How to check table size in db2 sap?

803


What is db2? Explain.

813


Why do we bind in db2?

908


How do you stop a db2 database in linux?

780


What is a trigger in the db2 database?

839