relation schema SQL Server 2005

relation schema SQL Server 2005

am 26.11.2007 10:53:09 von Erwin Moller

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

Re: relation schema SQL Server 2005

am 26.11.2007 14:08:47 von Erwin Moller

Erwin Moller wrote:
> 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