FK not shown / grayed

Visualizes SQL Server object dependencies.

FK not shown / grayed

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


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 12:11 pm

Postby Chris Auckland » Mon Nov 16, 2009 1: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 Auckland
Posts: 760
Joined: Tue Oct 24, 2006 1: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