This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

database tool

 
vikas jain
Ranch Hand
Posts: 37
  • 0
  • 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
  • 0
  • 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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic