Post reply

How to find out what the table relationship is

  • February 18, 2014 at 2:50 pm

    #304604

    Hi,

    I have started a new company and no one there is technical. They have advised me of a server and on this server is where they run reports against.

    What is the bets way to start, i.e how would i know what the relation ship between the tables and how would i know what the relationship is for that table i.e. is this a one-to-one, one-to-many or many-to-many, whta query would i need to run that would tell me this?

    Thanks

  • February 18, 2014 at 3:16 pm

    #1690082

    Here is a script that I use for that kind of stuff

    http://jasonbrimhall.info/2014/01/21/table-hierarchy-updated/

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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