Red Gate forums :: View topic - Is there a way to see type of a relation?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

Is there a way to see type of a relation?

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
larus



Joined: 16 Sep 2010
Posts: 6

PostPosted: Sat Feb 19, 2011 11:25 am    Post subject: Is there a way to see type of a relation? Reply with quote

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)?
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Mon Feb 21, 2011 2:35 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group