aspose file tools*
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: database tool