Add schema name to qualify table in intellisense
I love your intellisense but....
if you are working on a query in a different schema that the join you are making the schema name is to inserted.
for example let say you have scha.table1, schb.table2, schb.table3 with and FK defintion between the latter 2 tables
if you are in scha and start typing
select *
from schb.table2
inner join
intellisense wil propose the join with table3 (great) but if you select it it just insert
inner join table3 on .....
instead on schb,table3 on .....
1
vote
Thierry Steenberghs
shared this idea