theres a rather large DB system on a server where i work. i have to link it to another large server DB. the prob is that theres no documentation or diagrams on what tables are related and what columns are for. are there any programs/qwueries that i can run on a DB that will allow me to see what columns in what tables are related?( i dont want to have to trawl through the DB to find out all this info)
You could reverse engineer the db using the diagram option in EM to show tables related from a parent-child relationship standpoint, but from an application related standpoint you're going to be out of luck.