Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

database tool

 
vikas jain
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I am not sure whether this is a right forum.
But I am looking for a preferably java tool that can be used to search on the database.

Basically what I am looking for in this tool is that it should give me the list of all database objects where a particular column is being referenced.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Basically what I am looking for in this tool is that it should give me the list of all database objects where a particular column is being referenced.

Do you mean you are looking for a way to visualize foreign key constraints? Most DB tools out there can do this. squirrel sql is pretty good.

If you are looking for a tool that shows where a column appears in other database objects such as views and triggers, there isn't a tool that I can think of that does this. If this is what you were after you would probably have to write your own SQL queries against the database catalog.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic