dbTalk Databases Forums  

relation schema SQL Server 2005

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss relation schema SQL Server 2005 in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Erwin Moller
 
Posts: n/a

Default relation schema SQL Server 2005 - 11-26-2007 , 03:53 AM






Hi Group,

(I am just starting with SQL Server 2005.)
On SQL Server 7 I used often the nice relation schema, where I used to
draw out the whole database, especially the Foreign Keys constraints.

I found these relational schemas very handy to study an old database I
build a few years earlier that needs some updating.

I tried to find such an utility in SQL Server 2005, but cannot find it.
I did found the FK-constraints, but it is just an popup where I can
define them.

The overview such a visual schema gave was really great and I miss it.

Question: Is it gone in SQL Sevrer 2005, or do I just not know where to
look? If the latter, please guide me.

Thanks for your time.

Regards,
Erwin Moller

Reply With Quote
  #2  
Old   
Erwin Moller
 
Posts: n/a

Default Re: relation schema SQL Server 2005 - 11-26-2007 , 07:08 AM






Erwin Moller wrote:
Quote:
Hi Group,

(I am just starting with SQL Server 2005.)
On SQL Server 7 I used often the nice relation schema, where I used to
draw out the whole database, especially the Foreign Keys constraints.

I found these relational schemas very handy to study an old database I
build a few years earlier that needs some updating.

I tried to find such an utility in SQL Server 2005, but cannot find it.
I did found the FK-constraints, but it is just an popup where I can
define them.

The overview such a visual schema gave was really great and I miss it.

Question: Is it gone in SQL Sevrer 2005, or do I just not know where to
look? If the latter, please guide me.

Thanks for your time.

Regards,
Erwin Moller
Forget my posting. :-)
I found it.

I had to make an owner of the database before I could proceed.
Did that, and now I have my nice Database Diagram.
(Note to myself: It is named 'Database Diagram', not 'Schema'.)

Sorry for the noise. :P

Regards,
Erwin Moller


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.