What are the challenges you face when working across database platforms? Take the survey
Options

Is there a way to see type of a relation?

laruslarus Posts: 15
edited February 21, 2011 8:35AM in SQL Dependency Tracker
Is there a way to see what attributes are linked on tables (Primary key - foreign key) and what is the type of the relation (1:1, 1:N etc)?

Comments

  • Options
    Hi there,

    Thanks for your post. The only thing SQL Dependency Tracker will do at this point in time is show you what other objects are dependent on that particular object. With regards to PK's etc, since the tool only acts at the object level and not at the column level where the K's etc would be defined, this isn't possible either.

    We do however have a feature request in place to incorporate column level dependencies within the tool, however I do not know if / when this is likely to be implemented. In the meantime, you may wish to take a look at SQL Prompt 5 as this will show which columns are the PK and FK in your DB and also list other dependencies.

    HTH!

    Pete
    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
Sign In or Register to comment.