[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2708
  • Last Modified:

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?
0
Mr_Shaw
Asked:
Mr_Shaw
  • 2
  • 2
2 Solutions
 
St3veMaxCommented:
I dont believe you can, as a view is just that; a view of x tables where they are joined based on their relationships.

How about manually adding it ?
0
 
Mr_ShawAuthor Commented:
>>How about manually adding it ?
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?
0
 
tbsgadiCommented:
0
 
Mr_ShawAuthor Commented:
thanks
0
 
tbsgadiCommented:
Glad to assist
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now