1

What's the easiest way to get the SSMS stored procedure editor to recognize a view update? I have a stored procedure which references a view. I added a column to the view and I added a reference to that column to the stored procedure.

The stored procedure works but the new view column reference in the stored procedure still has a red squiggly line under it with a hover message of

Invalid column name 'MyNewColumn'

I right-clicked the db in SSMS and selected "Refresh" from the context menu and re-opened the stored procedure, but the ssms error in the editor still displays.

What's the easiest way to get the SSMS stored procedure editor to recognize this view update?

user9393635
  • 1,369
  • 4
  • 13
  • 32
  • 7
    Ctrl-Shift-R will refresh your intellisense. That might help. – dfundako Apr 22 '18 at 15:22
  • I agree with dfundako. This is probably the most useful keyboard shortcut in SSMS. This and Ctrl+R (that hides the result pane). – Zohar Peled Apr 22 '18 at 15:36
  • Possible duplicate of [SQL Management Studio won't recognize a table exists after scripted create](https://stackoverflow.com/questions/2201151/sql-management-studio-wont-recognize-a-table-exists-after-scripted-create) – gomory-chvatal Apr 22 '18 at 23:11

1 Answers1

1

You can use Ctrl+Shift+R keyboard shortcuts to refresh the IntelliSense Cache in SQL Server Management Studio.

You can also refresh the IntelliSense Cache by selecting Edit --> IntelliSense --> Refresh Local Cache.

enter image description here

How to automatically refresh the SQL Server Management Studio intellisense cache?

DxTx
  • 3,049
  • 3
  • 23
  • 34