Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic