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