FK not shown / grayed
kpl
Posts: 2
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.
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.
Comments
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.