Member Avatar for jemz

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 because: n/a
  • 2 Contributors
  • 1 Reply
  • 134 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by dnmurphy
Member Avatar for dnmurphy

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.