Home All Groups Group Topic Archive Search About

SQL Server visual design tool

Author
9 Jan 2006 7:57 PM
kcamhi
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

Author
9 Jan 2006 8:13 PM
Jesús López
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


Show quote
"kcamhi" <kca***@discussions.microsoft.com> escribió en el mensaje
news:A272E5D0-D696-4BE1-BD5B-06162494A66E@microsoft.com...
> 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
>
Author
9 Jan 2006 8:41 PM
kcamhi
Perfect, thanks.

Show quote
"Jesús López" wrote:

> 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
>
>
> "kcamhi" <kca***@discussions.microsoft.com> escribió en el mensaje
> news:A272E5D0-D696-4BE1-BD5B-06162494A66E@microsoft.com...
> > 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
> >
>
>
>
Author
9 Jan 2006 11:41 PM
William (Bill) Vaughn
Ah, VS has supported Database Diagrams for some time now. So has VB6.

--
____________________________________
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.
__________________________________

Show quote
"Jesús López" <sqlranger.***@mpvs.org> wrote in message
news:%23A4VomVFGHA.2648@TK2MSFTNGP11.phx.gbl...
> 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
>
>
> "kcamhi" <kca***@discussions.microsoft.com> escribió en el mensaje
> news:A272E5D0-D696-4BE1-BD5B-06162494A66E@microsoft.com...
>> 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
>>
>
>

AddThis Social Bookmark Button