I posted a question a few days ago about documenting a complex db. Anyway since then I have found some tools that have helped me with this process. To make a long story short I am at odds with this db that I trying to get to know.

This db has 77 tables and NO PRIMARY KEY or FOREIGN KEYS???
All of the tables are INDEPENDENT. It has many stored procedures and functions. How can this be? By all means I am not a SQL / DB guru but...

Pretty new to SQL, but I have had the good luck to be responsible for documenting a very sophisticated program that is a .net application. Anyhow the SQL side of the app is NOT documented with the database diagrams in SQL enterprise manager or with anything else for that matter.

I am not sure how this person setup the relationships/ primary key / foreign keys for these tables , but they appear to have none. How does one untangle the...