| Author |
Message |
kpl
Joined: 13 Nov 2009 Posts: 1
|
Posted: Fri Nov 13, 2009 1:18 pm Post subject: FK not shown / grayed |
|
|
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 |
|
 |
Chris Auckland
Joined: 24 Oct 2006 Posts: 710 Location: Red Gate Software Ltd.
|
Posted: Mon Nov 16, 2009 2:08 pm Post subject: |
|
|
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 |
|
 |
|
|
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