azuredatastudio icon indicating copy to clipboard operation
azuredatastudio copied to clipboard

Support IntelliSense drift detection so new objects aren't marked as errors

Open mpkarlo opened this issue 7 years ago • 2 comments

  • SQL Operations Studio Version: sqlops 0.23.6 (8a3011756318a2ded1e6e84332230a2b2bf9c544, 2017-11-06T21:51:43.232Z)
  • OS Version: Windows_NT x64 6.1.7601

I noticed this when following along in the quickstart guides and tutorials. I database TutorialDB and the table dbo.Customers. Then I opened a new query editor to follow along and it would mark the table as an invalid object 'Invalid object name dbo.Customers.'.

Steps to Reproduce:

  1. Open a query editor and create a table.
  2. Open a new query editor and write a select statement for the table created in step 1.

mpkarlo avatar Nov 22 '17 16:11 mpkarlo

@KMelendez there's a command to refresh the intelliSense cache you can use. By default the cache doesn't get refreshed by database changes

llali avatar Nov 22 '17 21:11 llali

@stevestein This is documentation item as well.

erickangMSFT avatar Dec 06 '17 17:12 erickangMSFT