Is there a way to see type of a relation?

[larus]

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)?

[peter.peart]

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