FK not shown / grayed

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

FK not shown / grayed

Postby kpl » Fri Nov 13, 2009 1:18 pm

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.
kpl
 
Posts: 1
Joined: Fri Nov 13, 2009 1:11 pm

Postby Chris Auckland » Mon Nov 16, 2009 2:08 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.
Chris
Chris Auckland
 
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