Once in a while we been in situations where you need to quickly understand/analyze a database given to you by others. We can go through each table and try to understand but it is usually lot simpler if you can visualize all the tables involved and relationships between those. Enter SchemaSpy: a free tool to do that. For sake of specifics, say the database given is MySQL and your pc is running some version of Windows.
A. Download and Install Pre-requsites (if you dont have already)
- Graphviz (http://www.graphviz.org/Download_windows.php)
- use MSI installer (see warnings specific to vista on the download page)
- Java (http://www.java.com/en/download/index.jsp)