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?