Is there a way to see type of a relation?

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

Is there a way to see type of a relation?

Postby larus » Sat Feb 19, 2011 11: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)?
larus
 
Posts: 6
Joined: Thu Sep 16, 2010 1:32 pm

Postby peter.peart » Mon Feb 21, 2011 2: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.

HTH!

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9: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