Geek Answers Handbook

Database Schema Schema With SQL Server

Is Visio the only way here?

I saw another stackoverflow question about this https://stackoverflow.com/questions/30474/database-schema-diagram-design-tool

And while Sql Designer is good, I do not want to draw all the tables manually. Is there a way to shortcut and load SQL DDL and it generates tables in a diagram?

+5
source share
2 answers

MS SQL Server has a built-in data diagram chart tool (in SQL Server Management Studio). Just right-click on the node database diagrams in the tree below the database from which you want to create the diagram ... After you have the empty diagram object, you can even create the actual database tables directly on the diagram

+8
source

MS Visio has the function of generating a database diagram from an existing database. For Vision 2008, go to Tools-> Add-Ons-> Visio Extras-> Database Wizard. I used it a few years ago, but I don't have a sql server to test it right now.

EDIT: Just saw that you specifically asked for SQL Designer. Take a look at manual .

The basics

:

...

  1. DB
+2

More articles:


All Articles