wood burning stoves 2.0*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
 
Don't get me started about those stupid light bulbs.
 
subject: database tool
 
Similar Threads
SQLite3 Tool(s)
Database modeling tool
JSF Automated testing tool
Java Mail Merge
Tool for creating Class diagrams from database