This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes Using DbVisualizer & Other Tools for Database Table Navigation Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Using DbVisualizer & Other Tools for Database Table Navigation" Watch "Using DbVisualizer & Other Tools for Database Table Navigation" New topic
Author

Using DbVisualizer & Other Tools for Database Table Navigation

Harshana Dias
Ranch Hand

Joined: Jun 11, 2007
Posts: 327
Hi,

1.How can we see what are the foreign key defines in a table using the above tool. (im using 6.5)
2.Any other Open Source better tool for database table navigation other than DbVisualizer or is this the best?

Thank You.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41046
    
  43
SQuirreL SQL is pretty good: http://squirrel-sql.sourceforge.net/


Ping & DNS - my free Android networking tools app
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968
    
    1

I actually just like using the Data tab that comes with Eclipse/Rational Application Developer.

-Cameron McKenzie
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

I thought there was an FK or constraints tab; don't have it in front of me at the moment though.

Personally, I think DB Visualizer is pretty good, although I've only started evaluating it. I also use the DB tools bundled with various IDEs, and for the most part, they're just as good--I still haven't justified the cost of DB Visualizer yet, but I might be able to provide more info after a few days.
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

Foreign keys are listed in the "Constraints" tab, identifiable by the value "Foreign Key" in the CONSTRAINT_TYPE column.

In addition, in the "References" tab, it shows a graphical representation of relationships, and if "Links to Columns" is selected and the node content is set to "Columns", the foreign key relationships will be obvious graphically.

(Note that setting "Links to Columns" may cause layout issues in larger graphs, though.)
Harshana Dias
Ranch Hand

Joined: Jun 11, 2007
Posts: 327
Yes David..Its there in the Reference tab. :D And when you select List in the view it will show in a table the foreign keys and where they come from. Thankx guys :thumbup:
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using DbVisualizer & Other Tools for Database Table Navigation
 
Similar Threads
Pros and Cons of DBVisualizer
SQL Developer and DbVisualizer
DbVisualizer vs Squirrel SQL
DbVisualizer: Does it have any forum
DbVisualizer