18+ Design Sql Server Table Relationship Diagram Example Download Zip Pictures. This tutorial provides you with a sql server sample database called bikestores, which allows you to start practicing with sql server quickly and effectively. How to visualize sql server database schema using database diagrams with free ms tool this will create a diagram with the tables columns, primary keys, and relationships that were read from the schema.
It is an entity relationship diagram tool that enables you to draw diagrams and generate sql server code.
For now you have diagram with all the tables but it might not look like the way you want it. In the following diagram we have two entities student and college and their relationship. Simply extract the zip to a fresh directory and run the sqldeveloper.exe in the top directory. Sometimes a table points back to itself.