This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes database tool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "database tool" Watch "database tool" New topic
Author

database tool

vikas jain
Ranch Hand

Joined: Apr 21, 2006
Posts: 37
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

Joined: Apr 14, 2004
Posts: 10336


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.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
GeeCON Prague 2014
 
subject: database tool