Home Dashboard Directory Help
Search

Auto complete inner joins using foreign keys by Ramon de Klein


Status: 

Active


2
0
Sign in
to vote
Type: Suggestion
ID: 801349
Opened: 9/18/2013 7:46:28 AM
Access Restriction: Public
0
Workaround(s)
view

Description

I write a lot of queries in SQL Server Management Studio. In most queries I need to perform joins. Most inner joins are based on foreign key relations, so it would be perfectly possible to propose a join clause.

Suppose I type the following query:

SELECT *
FROM Employee
INNER JOIN Company ON

And there is a foreign key that specifies that the Company_Ref column always refers to the Company's CompanyId column. In that case it could suggest to autocomplete this statement to:

SELECT *
FROM Employee
INNER JOIN Company ON Employee.Company_Ref = Company.CompanyId

This would save a lot of typing
Details
Sign in to post a comment.
Posted by Microsoft on 9/20/2013 at 1:09 PM
Hello Ramon.
Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you.
-Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Posted by daveadfadfadf on 9/18/2013 at 8:59 AM
The ANSI standard specifies a NATURAL JOIN which is kinda what you want. But that uses like named cols. I agree that a variant of NATURAL JOIN that uses key relationships would not only alleviate typing, but bugs too. It's real easy to get a JOIN col wrong if you aren't paying attention.

This also follows the principle of "don't repeat yourself." The JOIN condition should be declared once and then used everywhere.
Sign in to post a workaround.