• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

Using DbVisualizer & Other Tools for Database Table Navigation

 
Ranch Hand
Posts: 352
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Rancher
Posts: 43016
76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SQuirreL SQL is pretty good: http://squirrel-sql.sourceforge.net/
 
author and cow tipper
Posts: 5000
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I actually just like using the Data tab that comes with Eclipse/Rational Application Developer.

-Cameron McKenzie
 
Author
Posts: 12617
IntelliJ IDE Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 12617
IntelliJ IDE Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 352
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:
 
Eat that pie! EAT IT! Now read this tiny ad. READ IT!
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
    Bookmark Topic Watch Topic
  • New Topic