schematic

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?
lobosAsked:
Who is Participating?
 
QuothConnect With a Mentor Commented:
Lobos:
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?
0
 
mayhewCommented:
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.
0
 
lobosAuthor Commented:
Can you explain both of those comments?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

0
 
lobosAuthor Commented:
can you explain how that is done?
0
 
lajpatCommented:
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.

0
 
lobosAuthor Commented:
Everybody keeps saying that you can do this...and do that....well explain how to do it!
0
All Courses

From novice to tech pro — start learning today.