Visualizes SQL Server object dependencies.
Moderators: David Atkinson, Anu Deshpande
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.
Edit: We are using the Version 2.5.
- Posts: 1
- Joined: Fri Nov 13, 2009 1:11 pm
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.
- Posts: 757
- Joined: Tue Oct 24, 2006 2:12 pm
- Location: Red Gate Software Ltd.
Return to SQL Dependency Tracker 2
Who is online
Users browsing this forum: No registered users and 0 guests