Click here to Skip to main content
15,882,278 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I am using sql server 2012 server.My issue is that Table aliase is not fetching columns names automatically when i am writing queries.

Could someone help me to sort it out..Thanks!!

What I have tried:

Select * from department a where a.departmentid departmentid column has to be fetch automatically when i write a. This is not happening in my case.

I have also enabled intellisense in sql server2012 .But still its not working.
Updated 13-Jul-17 0:40am

1 solution

I assume your talking about intellisence

Couple of reasons for this.

1: There is an error on the page that is not allowing the whole script to be analysed
2: The intellisence cache has not been updated since a change was made (ctrl+shift+r to force)
3: Third party intellisence app has expired
4: It's turned off. check the link

Configure IntelliSense (SQL Server Management Studio) | Microsoft Docs[^]

Hope that helps :)
Share this answer
Member 13307901 13-Jul-17 8:08am    
checked those things ..still it not working.....
Richard Deeming 14-Jul-17 11:27am    
There's no "c" in "intellisense"! :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900