primary keys



primary keys

Postby rajeswarilt » Wed Nov 25, 2009 4:09 pm

Would like to know if there is any option in SPUFI or QMF to find out primary keys in a table.
rajeswarilt
 
Posts: 6
Joined: Wed Sep 16, 2009 12:27 pm
Has thanked: 0 time
Been thanked: 0 time

Re: primary keys

 

Re: primary keys

Postby dick scherrer » Thu Nov 26, 2009 1:25 am

Hello,

A table should have only 1 primary key.

You can write queries against the db2 catalog tables if you have been granted permission. Suggest you talk with your dba.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to Interview Questions

 


  • Related topics
    Replies
    Views
    Last post