What are the challenges you face when working across database platforms? Take the survey
Options

Not recognizing column via Intellisense

karenpaynekarenpayne Posts: 5 Bronze 1
edited September 19, 2016 10:13AM in SQL Prompt
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

Comments

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

    I'm glad to hear it!

    Let us know if you have any more questions!

    Best regards,

    David
Sign In or Register to comment.