(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 MollerErwin Moller wrote:
Quote:
Originally Posted by
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 Mollersql
No comments:
Post a Comment