Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
    
For which database? Oracle, MySQL,DB2, Sql Server –  Atilla Ozgur Apr 30 '12 at 20:49
1  
For Oracle possible answer here : dba.stackexchange.com/questions/973/… –  Atilla Ozgur Apr 30 '12 at 21:31
add comment

2 Answers

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
add comment

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.