SQL Server visual design tool

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kcamhi - 09 Jan 2006 19:57 GMT

Sorry for the beginner question... But are there tools in SQL Server or 3rd
party tools (for converting Access users) that are:

1. Like the Access "relationships" tool -- that lets you see all your tables
and drag and drop relationships

2. Like the Access query design tool?

Thanks for any pointers --

kc

Reply to this Message

Jesús López - 09 Jan 2006 20:13 GMT

Microsoft SQL Server Management Studio allows you to create diagrams.
Diagrams are the equivalent to Access relationships.

Microsoft SQL Server Management Studio also allows you to create views using
a designer similar to the Access query designer tool.

Regards from Madrid (Spain)

Jesús López
VB MVP

> Sorry for the beginner question... But are there tools in SQL Server or
> 3rd
[quoted text clipped - 9 lines]
>
> kc

Reply to this Message

kcamhi - 09 Jan 2006 20:41 GMT

Perfect, thanks.

> Microsoft SQL Server Management Studio allows you to create diagrams.
> Diagrams are the equivalent to Access relationships.
[quoted text clipped - 20 lines]
> >
> > kc

Reply to this Message

William (Bill) Vaughn - 09 Jan 2006 23:41 GMT

Ah, VS has supported Database Diagrams for some time now. So has VB6.

Signature

____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

> Microsoft SQL Server Management Studio allows you to create diagrams.
> Diagrams are the equivalent to Access relationships.
[quoted text clipped - 20 lines]
>>
>> kc

Reply to this Message

SQL Server visual design tool

Free Magazines