t sql - Can I configure SSMS intellisense to prefer autocomplete to aliases? - Stack Overflow

I'm not sure whether I inadvertently changed the behaviour of Intellisense in SQL Server Managemen

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条)

  • 暂无评论

联系我们

400-800-8888

在线咨询: QQ交谈

邮件:admin@example.com

工作时间:周一至周五,9:30-18:30,节假日休息

关注微信