how to know the prmiary key and foreign key (IBM DB)need help

Hello,,,

Hi,can you help me please i apologize if i post here.I don't know if i get the right forum to post....

Here is my problem in the IBM DB2 i created the database and i have 4 tables,but the problem is i forgot where did i make the foreign key..,can you help me please how can i determine the foreign key and also the primary key.is this possible?...

Thank you in advance and I'm hoping for your positive response.

jemz

Master Poster

763 posts since Jan 2010

Reputation Points: 9

Solved Threads: 0

10 Months Ago

You should be able to find this information from the system catalog. Its years since I did anything like this but all information about a RDBMS is found within the databse. Here is a thread which discusses it which may help.

http://ibmmainframes.com/viewtopic.php?t=262&start=0

Need to note though that the various DB2 platforms are not 100% compatible with each other, so something that works on mainframe DB2 may not work precisely the same on eg the Wiindows version.

dnmurphy

Newbie Poster

3 posts since Mar 2011

Reputation Points: 10

Solved Threads: 1

This question has already been solved

You