CODEWITHSUNDEEP
sql-servert-sqlssms
user9393635
user9393635

Reputation: 1429

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

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?

Upvotes: 1

Views: 186

Answers (1)

DxTx
DxTx

Reputation: 3357

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?

Upvotes: 1

Related Questions