Mr_Shaw
asked on
Viso Database relationships
I have reverse engineered my database which includes an SQL View.
I need to include the view inside my Viso schema diagram, but when I try and make the relationship Visio gives me the following warning.
Foreign Key Relationships can only be connected to entity shapes.
Hmm.. How can I solve this without making a key on the view in the actual SQL Server?
I need to include the view inside my Viso schema diagram, but when I try and make the relationship Visio gives me the following warning.
Foreign Key Relationships can only be connected to entity shapes.
Hmm.. How can I solve this without making a key on the view in the actual SQL Server?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
Glad to assist
ASKER
What do you mean.
I tried to add the view manually myself but I was not able to set the primary key.
Maybe I should create the view as an entity?