• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

I am trying to create a physical data model of an SQL Server Database. However I only want to use the Views not the tables. Is this possible?

Hi Experts,

I have to quickly create a physical data model of SQL Server database. However when I use the SSMS > Database Diagrams > New Database Diagram > I am only able to select tables.  However all the information that I have model is contained only in views.   I am not able to select the views?

Is there a way to do this? Otherwise is there some free alternatives? I also use visual studio but only the business Intelligence version so I don't have the option to use the data modally tool there I believe?

Many thanks,
2 Solutions
Vitor MontalvãoMSSQL Senior EngineerCommented:
I am not able to select the views?
Not in database diagrams since it's used to create and view relationships between tables only.

Is there a way to do this?
As far as I know, no. You can't relate views as you relate tables. Maybe what you are trying to do is a data dictionary?
The database diagram in SQL Server Management Studio is tables only and for a good reason.  One of the purposes of a diagram is to show the relationships between tables based on the primary key/foreign key relationships.  Views do not have those types of relationships, only the underlying tables do.  

As far as data modelling tools...  Microsoft Visio is pretty good if you have it.  You can add views.  Oracle has a pretty good one too.  

Hope this helps,

Anthony PerkinsCommented:
Alternatively copy the database and create tables from the Views.  You can then use the SQL Server Diagram.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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