• Post Reply Bookmark Topic Watch Topic
  • New Topic

Foreign keys and indexes

 
shankar vembu
Ranch Hand
Posts: 309
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
Could anyone tell me how to get a list of all the foreign keys and indexes for a particular table.
Thanx in advance,
shanks.
 
shankar vembu
Ranch Hand
Posts: 309
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
self-reply.
I got the answer .
I'll be using the methods of DatabaseMetaData viz. getCrossReference(), getExportedKeys(), getImportedKeys(),and getIndexInfo().
If anyone has already used this, they can provide me with the corresponding code snippets for reference.
shanks.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!