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:
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:
INNER JOIN Company ON Employee.Company_Ref = Company.CompanyId
This would save a lot of typing