Type:
select *
FROM [Sales].[SalesOrderDetail] AS sod
join
Hit space. Result: List of columns from SalesOrderDetail. Expected: List of tables.
Update: Once again, this behavior is dependant on whether there are columns in the SELECT list. And once again, that's behavior that just doesn't make sense; I often work with the FROM/JOIN/WHERE clauses before going back to fill in the SELECT list (after all, that's the logical order that SQL works in).
Hit space. Result: List of columns from SalesOrderDetail. Expected: List of tables.
Update: Once again, this behavior is dependant on whether there are columns in the SELECT list. And once again, that's behavior that just doesn't make sense; I often work with the FROM/JOIN/WHERE clauses before going back to fill in the SELECT list (after all, that's the logical order that SQL works in).