Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dmarron1
Starting Member
1 Post |
 Posted - 2014-10-14 : 09:35:24
|
| Hi,I have been asked to figure out a database which was designed and developed by someone else who is no longer about.There is not even one foreign key relationship in the database. There are 90+ tables.So, my question is is there any tool that can trawl through each table and compare field values to other tables to see if they find a match. We could then assume that it is a foreign key and highlight it for inspection.Thanks.Des, |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-14 : 11:34:29
|
| try Apex Search (google it) |
 |
|
|
|
|
|
Foreign keys not used!!