Can a table have more than one primary key

2 posts / 0 new
Last post
Anonymous
Can a table have more than one primary key

Is it possible for a DB2 table to have more than one primary key in any scenario? I am new to DB2 and was asked this quesion in an interview...

Please help

"; ; ; ;
Anonymous
DB2 table to have more than one primary key in any scenario?

No, There cant be more than one primary key in DB2 table. but can be more than 1 candidate key in Db2 table. Actually candidate key is the super set of Primary Key. From the candidate key we select primary key that uniquely identify a record in a table.

Log in or register to post comments
Sponsored Listing