|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server visual design toolSorry 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 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 > 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 > > > > > Ah, VS has supported Database Diagrams for some time now. So has VB6.
-- Show quote____________________________________ 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. __________________________________ "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 >> > > |
|||||||||||||||||||||||