0

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.

Edited by jemz: n/a

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by dnmurphy
0

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.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.