<div>
You're going to need a modeling tool like ERWIN.<br />
<br />
Either that or you could just create links to the SQL Server tables in Access and use Access to design the schematic.<br />

</div>


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.


<div>
Can you explain both of those comments?<br />

</div>


<div>
You can create the schematic view in MS SQL using Enterprise manager. <br />
<br />

</div>


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



<div>
can you explain how that is done?<br />

</div>


<div>
In Enterprise manager, database &amp;&nbsp;diagrams allwo you to create ER.<br />
Please let me know wheather I understood the question correctly or you have different meaning for Schematic View.<br />
<br />

</div>


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.



<div>
Everybody keeps saying that you can do this...and do that....well explain how to do it!<br />

</div>


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


<div>
<div class="content wysiwyg-content">
I have a bunch of table with foreign keys and primary keys. &nbsp;I want a schematic of all the tables and there relationships, in access it's no problem but how is it done in SQL?
</div>
</div>


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?

schematic

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.