Monday, November 6, 2017

Database Diagrams!

In SSMS 17.1 at the pseudofolders beneath a database in the "Object Explorer" which are titled Database Diagrams, Tables, Views, External Resources, Synonyms, Programmability, Query Store, Extended Events, Storage, and Security, right-click on Database Diagrams and pick "New Database Diagram" to make a visual representation of how some database tables interact (you will be able to cherry pick which tables) not unlike an Entity Framework .edmx. You may right-click in the white space around the diagram to find an option for "Zoom" which does what you'd expect.

No comments:

Post a Comment