Posted on 1999-06-22
Medium Priority
Last Modified: 2010-03-19
I have a bunch of table with foreign keys and primary keys.  I want a schematic of all the tables and there relationships, in access it's no problem but how is it done in SQL?
Question by:lobos
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 1095869
You're going to need a modeling tool like ERWIN.

Either that or you could just create links to the SQL Server tables in Access and use Access to design the schematic.

Author Comment

ID: 1095870
Can you explain both of those comments?

Expert Comment

ID: 1095871
You can create the schematic view in MS SQL using Enterprise manager.

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf


Author Comment

ID: 1095872
can you explain how that is done?

Expert Comment

ID: 1095873
In Enterprise manager, database & diagrams allwo you to create ER.
Please let me know wheather I understood the question correctly or you have different meaning for Schematic View.


Author Comment

ID: 1095874
Everybody keeps saying that you can do this...and do that....well explain how to do it!

Accepted Solution

Quoth earned 100 total points
ID: 1095875
In SQL Server 7.0 Enterpise manager expand out the server that your databases resides on, expand out the databases folder, and then expand out the database for which you want to create the "schematic."  Inside the database you will see a list of items, such as tables and stored procedures.  One of these items will be labled "Diagrams."  Click on the diagrams item on the left; the right pane of EM will display all of the diagrams currently created for your database, if any.  Right-click in the right pane and select "new diagram" from the pop-up menu that appears.    This will run a wizard that allows you to select which tables in the database you would like to add to the diagram and then arranges the tables for you.

SQL Server stores the information for the diagrams in a new system table called dtproperties.  You can add as many diagrams as you like to a database with all of the tables or just a subset.

SQL Server 6.5 SP5 is supposed to allow you to do the same thing using the Visual Database tools that are included with Visual Studio, but I haven't played with 6.5 since SP5 was released.

Does this help?

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question