faqts : Computers : Databases : Microsoft SQL Server

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

0 of 6 people (0%) answered Yes
Recently 0 of 6 people (0%) answered Yes

Entry

Database: Microsoft SQL server: How to get overview relationship tables in an existing diagram?

Oct 16th, 2004 17:31
Knud van Eeden, Deepak Bansal, Rachit Bagda,


----------------------------------------------------------------------
--- Knud van Eeden --- 24 December 2003 - 00:49 am -------------------

Database: Microsoft SQL server: How to get overview relationship 
tables in an existing diagram?

---

Thus here you are looking at a graphical representation of the
relationship between your tables, using an already existing diagram.

---

Steps: Overview:

 1. -Start Microsoft SQL server 'Enterprise manager'

 2. -In the left pane click '+'
    of 'Microsoft SQL Servers'

 3. -click '+' of 'SQL Server Group'

 4. -click '+' of your server
     (e.g. (local) (Windows NT))

 5. -click '+' of 'Databases'

 6. -click '+' of your database

      e.g. select the 'Northwind database'
           on my computer here

 7. -double click on icon 'diagrams'
     in the right pane

 8. -Double click on the diagram of your
     choice

      e.g.

       mydiagram1

---
---

Internet: see also:

---

Database: Microsoft SQL server: Enterprise manager: Table: Diagram: 
Overview: Can you give overview?
http://www.faqts.com/knowledge_base/view.phtml/aid/27877/fid/147

----------------------------------------------------------------------