How can we help you today? How can we help you today?

Not recognizing column via Intellisense

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
karenpayne
0

Comments

3 comments

Sort by
  • 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
    David Priddle
    0
  • karenpayne
    Thanks David, I did end up finding out about the refresh not more than five minutes after pressing submit on this thread :)
    karenpayne
    0
  • David Priddle
    Hi Karen,

    I'm glad to hear it!

    Let us know if you have any more questions!

    Best regards,

    David
    David Priddle
    0

Add comment

Please sign in to leave a comment.