I have a database where I created some tables and some foreign keys between them.
When I create a new diagram and show the tables, the FKs are not showing. But in the Object Explorer they are there.
I also ran a query to show them:
select f.name as ForeignKey, OBJECT_NAME(f.parent_object_id) as TableName,
COL_NAME(fc.parent_object_id, fc.parent_column_id) AS ColumnName,
OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,
COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS ReferenceColumnName
from sys.foreign_keys f
inner join sys.foreign_key_columns fc ON f.OBJECT_ID = fc.constraint_object_id
and they show there.
I have other databases that show the relationships fine.
I can create the FKs on the diagram and they show correctly. Just not when I add them from the add table option.