How to know the Primary and Foriegn keys?

[arrbee]

Hi,

It is asked in an interview that how to know the Primary and Foriegn keys of a DB2 Table? As a programmer, we generally don't have the DBA authority to look at the create table?

Is it possible to find out using SPUFI (SELECT * from table;)?

Please suggest.
_________________
Arr Bee
-------------
?My joy in learning is partly that it enables me to teach? - Seneca(Roman philosopher, mid-1st century AD)

[pkaushi]

[Kalicharan]

Hi,

With DB2-FileAID also we can find the PRIMARY & FOREIGN keys...

Fron DB2-FileAID,
--> 3.4
--> Mention Object Name & Object Type and select TABLE
--> I command against table (I --> Information)
-->Index Key Information(In this select Unique Key for Primary Key)
--> Related Table Information to get Foreign Key Information

Thanks
Kali

[Kalicharan]

Hi,

This another way of knowing Primary Key and Foreign Keys using DB2 SYSDBASE table (SYSIBM)

For Primary Key==>

Select NAME from SYSIBM.SYSCOLUMNS

where TBCREATOR = XXXXX and TBNAME = XXXXX

and KEYSEQ > 0 order by KEYSEQ ASC

For Foreign Keys==>

Select A.REFTBNAME ,COLNAME FROM SYSIBM.SYSFOREIGNKEYS A, SYSIBM.SYSRELS B

WHERE A.RELNAME = B.RELNAME

AND A.TBNAME = XXXXX AND A.REFTBCREATOR = XXXXX

AND A.REFTBCREATOR = B.CREATOR


Thanks
Kali.

[arrbee]

Thanks Kalicharan. Sadly, we don't have File-Aid for DB2. I will try the other method told by you.

Thanks a lot.
_________________
Arr Bee
-------------
?My joy in learning is partly that it enables me to teach? - Seneca(Roman philosopher, mid-1st century AD)

[vijay]