• Post Reply Bookmark Topic Watch Topic
  • New Topic

Foreign keys and indexes  RSS feed

 
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
Boost this thread!