Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am currently using TOAD to connect to the database. I have around 20 tables that I have been asked to analyze ( I am new to project ). I think the first place to start is to understand the relation between tables.

  • I am wondering if there is a schema analyzer tool or something in TOAD or a free tool available that can help me understand the relation between tables?
share|improve this question

closed as off-topic by Paul White, Phil, Aaron Bertrand Jan 26 '15 at 14:44

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, Phil, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

For which database? Oracle, MySQL,DB2, Sql Server – Atilla Ozgur Apr 30 '12 at 20:49
For Oracle possible answer here :… – Atilla Ozgur Apr 30 '12 at 21:31
up vote 1 down vote accepted

The most reliable schema analysis tool is something that lets you dump the DDL for the indexes and contraints and a SQL command line for writing queries against the real table data.

One of the problems with trying to take a shortcut with an automated tool is that what the designer first had in mind may not be exactly what the programmer built and is too often nothing like what the user actually entered into the system.

I have reverse-engineered several systems and found shocking divergences between the presumed ERD and what was actually in place in the production tables.

share|improve this answer

There are some tools available like Red-Gate's SQL Dependency Tracker. I think it is important to take Joel's point. It can be a great learning experience by dissecting them manually.

share|improve this answer