April 20, 2016 at 11:40 pm
hi one and all
in my project we have a database which was designed ,in this database,
we have Tables which was designed only with primary key,there is no references between the Tables,how do i find out relationship between tables ?
Thanks
Linga
April 21, 2016 at 1:57 am
There won't be any relationships.
You have to code it in with FKeys and Pkeys.
If you have Pkeys on Identities, then use this.
http://www.sqlservercentral.com/scripts/integrity/136833/
It will give you a rough guess how tables could possibly be related.
Dont go creating foreign keys willy-nilly.
If the script suggests FKeys, check the data in those columns, that they are as expected.
Then test the FKeys in QA with the application that runs on top of this DB.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply