DataBase

  • 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

  • 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.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply