Not recognizing column via Intellisense

karenpayne

I'm using 7.2.4.291, SSMS version 2012

I add a new column to a table, do a SELECT e.g.

Person table had FirstName, LastName, Prompt recognizes both columns.

Close query windows in SSMS.

Alter table, add column Gender.

New query

SELECT FirstName, LastName, **** FROM Person

Intellisense worked for FirstName, LastName but not Gender.

Close SSMS, re-open, now Gender is shown in Intellisense.

QUESTION: Is this a bug, not recognizing the newly added column (and I have done this on other tables too)?

Thanks for your assistance,
Karen

David Priddle

Hi Karen,

SQL Prompt keeps a cache containing data about databases it's connected to locally, and doesn't know about changes to the database unless it's told about them. You can force SQL Prompt to refresh the cache by using Refresh suggestions (Ctrl + Shift + D).

If you're connecting to small databases you could turn on the Automatically refresh suggestions feature in the Experimental features options page - this will check for changes to the database every few minutes and will also refresh the cache when you run a script that contains a modification statement.

Please let me know if this helps you.

Best regards,

David

karenpayne

Thanks David, I did end up finding out about the refresh not more than five minutes after pressing submit on this thread

David Priddle

Hi Karen,

I'm glad to hear it!

Let us know if you have any more questions!

Best regards,

David