Viso Database relationships

Posted on 2009-12-22
Last Modified: 2013-11-26
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?
Question by:Mr_Shaw
    LVL 13

    Accepted Solution

    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 ?

    Author Comment

    >>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?
    LVL 46

    Assisted Solution


    Author Closing Comment

    LVL 46

    Expert Comment

    Glad to assist

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now