Is there a way to see type of a relation?

Visualizes SQL Server object dependencies.

Is there a way to see type of a relation?

Postby larus » Sat Feb 19, 2011 10:25 am

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)?
Posts: 9
Joined: Thu Sep 16, 2010 12:32 pm

Postby peter.peart » Mon Feb 21, 2011 1:35 pm

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.


Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Site Admin
Posts: 362
Joined: Tue Sep 02, 2008 8:58 am
Location: Top floor, RG towers with the cool kids

Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests