Red Gate forums :: View topic - FK not shown / grayed
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

FK not shown / grayed

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



Joined: 13 Nov 2009
Posts: 1

PostPosted: Fri Nov 13, 2009 1:18 pm    Post subject: FK not shown / grayed Reply with quote

Hi,

when I create a new project, select the database and then select the objects in the database, the foreign keys and the Indexes are grayed.
I'm logged in as a db_owner. But they are grayed...
After created the diagram I don't find any Options for showing the FK or the Indexes.

Hope someone can help me to bring up this two options.

Thanks

Edit: We are using the Version 2.5.
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon Nov 16, 2009 2:08 pm    Post subject: Reply with quote

Thanks for your post.

The foreign keys are shown 'grayed' as they are not treated as objects in their own right, and cannot be checked or unchecked.

Once the tables are added to the diagram, you can select the table object and you will see the FK shown in the 'Dependencies' in the bottom right.

If you want to see the FK as an object on the diagram, you can select 'View' > 'Constraints as Objects'

I hope this is helpful.
_________________
Chris
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