Generating ER Diagrams and Join conditions from SQL files
Posted on 2007-11-15
I have been given a load of .sql files, .ksh files and .ddl files which represent a database and a number of scripts that pull and manipulate data within the database.
Apart from some random code comments I am struggling to understand the overall structure of the database and the function of the scripts.
I was after some advice as to whether there were any tools out there that could help my by processing the files and generating an ER diagram or describing the joins etc.
Any help would be much appreciated.