visual diagram of relations among SQL server's system tables 
Author Message
 visual diagram of relations among SQL server's system tables
i have seen somwhere in help a visual diagram of relations
among SQL server's system tables. I can't locate it now.
Does anybody knows where it was?

Thank you.



Sun, 14 Nov 2004 19:39:15 GMT
 visual diagram of relations among SQL server's system tables

In Enterprise Manager expand one of the databases and you'll see the
Diagrams folder. Right-click on it and from the pup-up menu create new
diagram.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


Quote:
> i have seen somwhere in help a visual diagram of relations
> among SQL server's system tables. I can't locate it now.
> Does anybody knows where it was?

> Thank you.



Sun, 14 Nov 2004 20:32:10 GMT
 visual diagram of relations among SQL server's system tables
When you create a diagram this way, be aware that you are creating
constraints that will enforce the referential integrity.  That is
probably what you want to do ... but in SQL 7 it will prevent deletions
-- you don't have the option to cascade them.  Just an FYI.

--
Daniel Wilson, BSCS, MCSE
CompuSoft Solutions and The Worthwhile Company
www.worthwhile.com
Your complete e-business solution partners.
Phone: 864-233-9029 Fax: 509-757-5264

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Sun, 14 Nov 2004 21:14:10 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Visualizing relations among tables

2. Where is the SQL Server 7.0 System Table Diagram

3. SQL Server 7.0 System Table Diagram

4. SQL Server 7.0 and 2000 system table diagrams

5. SQL Server 7.0 and 2000 system table diagrams

6. SQL Server 7.0 and 2000 system table diagrams

7. Question about m:n relations in SQL Server 2000 Diagram Tool

8. can't set relations with diagram tool

9. system tables diagram for SQL 7

10. System Tables relationship diagrams, MS SQL 2000

11. Sql System tables Diagram

12. copy 'text"-field among tables


 
Powered by phpBB® Forum Software