Problems with Intellisense drop down box not updating
v 6.3.341
Open a SQL editor window, write a SELECT query - list the FROM tables, start to build SELECT clause.
Don't save Query - leave open in editor. Open a Table being referenced in query, and add a new field. Switch back to SQL editor. The new field doesn't appear in the Intellisense drop down (or whatever you call the drop down box - MS call it Intellisence) as you type.
I was doing this in the SELECT clause. I had also given the tables aliases in the FROM clause, if that make any difference.
Many thanks.
1
vote
Timbald
shared this idea
-
Timbald
commented
PS I realise there is an auto refresh cache preference - which may or may not trigger, but after any editing to a table, shouldn't the cache be automatically updated as a matter of course?
Thanks.