I'm not sure whether I inadvertently changed the behaviour of Intellisense in SQL Server Management Studio, but it has started to behave in a way that, to me, is infuriatingly annoying.
I'm using SSMS version 20.2
For example, I want to list the names of objects and the status of Fulltext Indexes against those objects. So I start typing
select
from sys.fulltext_indexes [FI]
inner join sys.objects [SO]
on [SO].object_id = [FI].object_id
Now I place the cursor after the "select", and start typing
select [SO]
from sys.fulltext_indexes [FI]
inner join sys.objects [SO]
on [SO].object_id = [FI].object_id
At this point the cursor is right behind the closing bracket after "select [SO]". I now want to start listing column names so I hit the "." and....
select [SOUNDEX].
from sys.fulltext_indexes [fi]
inner join sys.objects [SO]
on [SO].object_id = [fi].object_id
As you can see, instead of accepting my alias [SO], intellisense has "autocompleted" it to [SOUNDEX] and I now need to go back to correct it back to [SO] again.
It does that with a lot of built in functionality and it's driving me demented. Is there a way to configure it so it prefers my aliases over built in functionality ?
发布者:admin,转转请注明出处:http://www.yc00.com/questions/1744151844a4560678.html
评论列表(0条)